Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ligang1000
  • Order by date
  1. ligang1000

    Release space in oracle database after deleting records through SQL

    1. Export with merge option 2. Drop table 3. Import table Chinese can eat everything
  2. ligang1000

    Check whether application is already running or not

    You need not to pass the parameter , just implement the code I gave to you :-) Best regards LiGang U get , U given ..
  3. ligang1000

    Create Table error driving me mad!

    It's nothing to do with technical side , It's because of careless - typing mistake APPLICATION_DAY NUMBER(2), APPLICATION_MONTH NUMBER(2), APPLICATION_YEAR NUMBER(4) MARITAL_STATUS VARCHAR(1), Commas missing after column application_year Best regards LiGang U get...
  4. ligang1000

    Check whether application is already running or not

    Put follow coding somewhere in your app startup section: Appln_handle = OpenChannel ( 'appln','Appln') IF Appln_handle < 0 then StartServerDDE('appln','Appln') ELSE MessageBox(&quot;Application Already Running .&quot;, &quot; You cannot start it again.&quot;) CloseChannel(Appln_handle)...
  5. ligang1000

    highlighting the current Item

    Why not specify your condition in the DW design ? It will be much simple Best regards LiGang U get , U given ..
  6. ligang1000

    How can I check whether I'm connected to a database?

    THen U must use 4 SQLCA , So you should check sqlcode for each one , because it's the only indicator . Best regards LiGang U get , U given ..
  7. ligang1000

    How can I check whether I'm connected to a database?

    select count(*) into li_test from dual ; Check sqlca.sqlcode , if it's not equal 0 , Means connection is wrong .
  8. ligang1000

    Switching an object name in the code for a data window

    dw_controlname.DataObject = name of datawindow I'm not sure whether my understanding to your question is correct
  9. ligang1000

    Datawindow Query Mode and wild characters ('%','_')

    I think you should write you wild card in where cause like : ... where A like '&'||arg1 ....
  10. ligang1000

    GroupBy in DW

    From your example , I think it's the basic function of PB datawindow . I don't think any trick in it . DOn't use script just bying forming your datawindow .
  11. ligang1000

    Running an Oracle sql script via Cron

    Can U consider to use ProC ?

Part and Inventory Search

Back
Top