Recent content by fluppe689

Dear Experts I have exported a cursor to excel with the following result UK 683384,99 SLOVAKIA 58911,24 SWISS 3296,00 SINGAPORE 43768,57 SENEGAL 4411,50 POLAND 6264,53 NEDERLAND 53529,29 INDIA 19040,34 GERMANY 180,00 FUERTEVENTURA 31259,70 FRANCE 228053,50 CZECH REPUBLIC 53792,14 CABO VERDE...

Hello Experts Does someone knows how to convert a date to a timestamp Wfg, Filip

Mike, Boris Thank you very much, I should have known this, using allways go bottom and go top!!! Wfg, Filip

Hello Borislav, That is not my problem. My problem is how to replace zone xxx from cursor file 1, RECORD ONE with zone yyy from cursor file 2, RECORD ONE and then from file 1 RECORD TWOO with file 2 RECORD TWOO, RECORD 3(file1) with RECORD 3(file 2) So my problem is basically how to find...

Hello Experts, This will probably easy but i don't know the answer I have 2 cursor files coming from 2 selects. I want to do the following replace in cursor file 1, record 1, zone 3 with zone5 from cursor file 2 record 1 and then the same whit record 2 from file 1 with record 2 from...

Thanks Mike, question 1 : how can I import agenda of different users ? question 2 : how can i know how much items ther are ? Wfg, Filip Merlier

Dear Experts, Is it possible to read en use the information from different agenda's from exchange server. And if this is possible how to do ? wfg, Filip Merlier

Hi, Dear Experts, Is it possible get in a cursor file the caption of all labels, checkboxes, commandboxes of a certain form Wfg, Filip Merlier

Hey all Experts, I ha a problem importing a csv file the layout is the following Naam,Email,Bestelnummer,Kunstgras,Type kunstgras,Verbruik per m2,Type kunstgras (b),Verbruik per m2 (b),Accessoires,Type accessoire,Verbruik,Type accessoire 2,Verbruik 2,Type accessoire 3,Verbruik 3,Type...

Dear Experts oExcelObject = CREATEOBJECT('Excel.Application') * WITH oExcelObject .Application.Workbooks.Add .APPLICATION.DisplayAlerts = 0 .APPLICATION.DisplayAlerts = 1 .Application.Worksheets(1).Activate .Application.Worksheets(1).name = "DETAIL" ENDWITH...

Ok Olaf, I think i have still a lot to learn, even when it is almost to late for vfp Wfg, Filip

Yes Olaf, I did all of those things but the import as you discribe doesn't work because of some fields wre greater than 255 characters Mt original instruction was : SQL = "bulk insert " + m.y_db1 + "f_extern from " +CHR(13) +; "'" + m.bestand + "' " +; "with (CODEPAGE ='RAW'...

Dear Experts, I Had a problem with inserting a csv file that a got from a unix server in utf-8 into an sql server table with 30 columns all text I tried is several times with a bulk insert instruction but that did not work There were twoo problems : text was utf-8 and eof line was only LF...

hallo Olaf, Found the problem: changed m.bestand = ALLTRIM(m.xxextdir) +gaDatabase(nCount,1) into "\\server02\data\merlijn\aanvragen\" + gaDatabase(nCount,1) That does the job, Thanks in any case for your help Filip

Hy Olaf, the line of code where is happens is SQL = "bulk insert " + m.y_db1 + "f_extern from " +CHR(13) +; "'" + m.bestand + "' " +; "with (CODEPAGE ='WIDECHAR', MAXERRORS = 100,DATAFILETYPE = 'widechar',FIELDTERMINATOR = ';',ROWTERMINATOR...