Recent content by dejanj

Dear All, I 've found this article from Fox Advisor ( Jul 2002 ) in TIps section. When i tried i can't seem to be able to send data to HTTP the method open returns the contents of ASP page. According to article i should be able to send data via Post to ASP page Maybe someone can test it and...

Thanks Dima , Mufasa Since in SQL PLus SET COMMIT is by default OFF i needed it. so set define '^'; INSERT INTO GCC.SGCCSUSR ( ENCRYPTED ) VALUES ('18571!"#$% !"AEOLR% !"Dhrou(Hlvxz''vcpi%&''(#$%&''("#$%&''("#$%&''(Dhrou(Ndwy&uioh$%&''(cbdv$%...

Thanks Mufasa, I did in SQL pLus set define '^'; INSERT INTO GCC.SGCCSUSR ( ENCRYPTED ) VALUES ('18571!"#$% !"AEOLR% !"Dhrou(Hlvxz''vcpi%&''(#$%&''("#$%&''("#$%&''(Dhrou(Ndwy&uioh$%&''(cbdv$% !"1214541015 !"DLLLWAB"#$% !" !&quot...

Dima, SantaMufasa Thanks for your replies. Really appreciate it. I found out this strange behaviour!! THis is Oracle8i. I am using Win2000 as Oracle Client and Oracle8i database is on another PC on the network. WHen i use SQL PLus worksheet to insert the record in table INSERT INTO...

Thanks guys, Much appreciated for the tip. I am trying to create a script in SQL PLus for Oracle for that insert and adding ' to single quotes works but then Oracle SQL Plus complains saying that column is not long enough for the value to be inserted. I am trying to use EXP feature once i...

Dear All, Does anyone know how to insert " (double quotes) and ' (single quotes ) into oracle8i table. For example i 'v got a table : CREATE TABLE "GCC"."SGCCSUSR"("ENCRYPTED" VARCHAR2(132) NOT NULL); ..the value i need to insert is 18571!"#$%...

Hi Jim, Thanks for help. It is appreciated. I posted my Q. on Oracle ERP Solutions forum but no luck. I 've found that i can use LONG data type in ORACLE for Foxpro's Memo. Oracle8i states that you can have only 1 LONG per table. I have created table CREATE TABLE...

Hi All, Can anybody tell me how to upsize this 2 tables in Oracle8i from Visual Foxpro 6. They both uses Memo fields. What field type should i use in Oracle8i? FUNCTION MakeTable_SGCCELOG ***** Table setup for SGCCELOG ***** CREATE TABLE 'SGCCELOG.DBF' NAME 'SGCCELOG' (USER C(10) NOT NULL, ...

Hi All, Can anybody tell me how to upsize this 2 tables in Oracle8i They both uses Memo fields. What field type should i use in Oracle8i. I am using VFP7. FUNCTION MakeTable_SGCCELOG ***** Table setup for SGCCELOG ***** CREATE TABLE 'SGCCELOG.DBF' NAME 'SGCCELOG' (USER C(10) NOT NULL, ...

Hi All, I would like to automate process of starting up Oracle 8i database on WIN2000 machine. I understand i can set to start Oracle8i ( SID ) service to automatic ( using Services control panel ) but i would like to automate the sequence of starting and shuting down Oracle database through...

Mike, Thanks for jumping in to help. I did check. It didn't make any difference with ticked pencil icon for PK or not. When i run TABLEUPDATE(.T.) it still dosn't show in the view. Only when i issue requery(). There must be something else... I understand when i use surogate PK i don't display...

Hi All, I would like to insert all the values at the time of saving in remote view but oracle or Foxpro doesn't save the value for primary key. Once i am on the record ( remote view ) which i am updating or adding only after REQUERY(), value in my primary Key field appears. Expl. TEST with 2...

Mike, Here is a test what i did: I open the database in Foxpro, set dele off. Run the view use wgsms!unrouted_lv and it returns 4 records set buffering to 5 and then either issue DELETE to mark the record for deletion or just click on grid record marker. Record(s) are marked for deletion then i...

Hi Mike, Thank you very much for the tip. Yes it works beautifully for remote views. I set on Init of the page set dele on then requery() then set dele off and in activate i have set dele off and grid behaves when i issue tableupdate(.t.,.t.) i requery() and the records are gone from the...

Dear All, This seems to me as bug in VFP7. I am running VFP7 SP1 and my client wants to have ability to selectivly delete records from the grid. Problem: Client ( VFP7 ) is running remote view against VFP database ( VFP7 SP1) I am running remote view with TABLEBUFFERING and multilocks ON. My...