Search results for query: *

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...

Olaf, The error turns on everty time i do the sqlexec, just on the server not on my pc. This code i wrote above is a part of a class that runs every app. every 10 min. So when there is a csv file i get the error on the server of my client, and again not on my pc. Yes in the csv there van be...

hello Yosua how is your sqlexec statement. when you have a cursor file for example sql = "select * from dbo...." retcode = sqlexec(handle,sql,"t_label") if retcode > 0 select t_label go top count to m.i if m.i > 0 select t_label go top *** then do this...

Hello Experts, I have a problem with a bulk insert. On my local machine (windows xp with a full sql 2008 r2) everything works fine. The problem exists on the database on location with my client. (windows server 2008 with an sqlexpress 2008 r2) my instruction is : sql = "select * FROM " +...

Hello all experts, I changed the field on the server in datetime and i don't have any problems anymore for the moment But what is for my not understandable is that is worked fine on my local pc Filip

Hello, The type of the field in sql is date I do the replace only in my cursor file What do you mean i can not use date type when using ODBC I have that on serveral program's and that works perfectly Wfg, Filip