Search results for query: *

Hi All, Has anybody found following with VFP6 earlier? ? 1333365.89000 * 100 -> 133336589.0000 ? int(1333365.89000*100) -> 133336588 Whay is the second expression returns 133336588? I was expecting 133336589. Foxbldr

Hi all, I am using VFP 6 on Novell/NT environment. When I use File() or Sys(2000) to check the existance of files it returns TRUE even when the exact file names are not found. Files names look like: DT060815_P_L.dbf DT060815_P_S.dbf DT060815_P_X.dbf... etc When I use File("DT060815.dbf") or...

Hi All, I am running a VBA module that uses QueryTable object to populate a worksheet. I am getting an error with following line although my sql string looks ok. With activesheet.QueryTable(....) .Sql= Array(strSqlStatement) ... end with strSqlStatement =" select ..,...,...,... from...

Hi All, I have stored a sql script in text file which look like following: Select Code, CodeDesc, EffDate from DTran where Code =' StrCode ' I read contents of text file into a string and pass the string to a QueryTable object. StrCode is a string variable in my module. If StrCode is...

Hi All, In a table, I have a character field called DESCRIP which look like: xx bb zzz kk x bbb zzzz kkk xxx bb zzz kk xx b zzz k I want select Xs, Bs, Zs and Ks into four different fields and each value is separated by a space. Whenever I write: Select left(DESCRIP, AT(" ", DESCRIP,1)-1)...

Hi All, I have pre-built pivot table forms in my access database. I want to see the underlying datasources for each and every pivot table form. Tried both property sheets of forms and pivot table object but, datasourece, recordsource are blank. Any help is much appreciated. FoxBldr

Hi all, I have bunch of text files that contain sql statements: ie. contents of Loan.txt (command continuation added at eol) select ......,........,; from .................. ; where ..... ; order by .., .. into cursor .... Can somebody suggest me an efficient way of executing queries...

Hi All, I am calling DB2 stored procedures within VFP6 prgs. When I issue my call inside DB2 command center, it works but calling withing VFP6 gives me errors without any clue. From DB2 command Center: Call Get_MonthSum ('B1','2006-05-01','2006-05-31',?,?) From VFP6: lcDB2Call= " Call...

Hi All, When I view my aspxs on http:\\localhost, it displays actual source code. I registered dll and ran aspnet_regiis.exe too. Can somebdoy help me? tx Foxbldr

I want to download files (TIF/FAX) from a site without any user interaction. (At the moment, user opens the page, points to the link, then "Save Target As" for each and every file.) I have posted some HTML codes below and what user wants to download are report1.fax, report2.fax and report3.fax...

Hi all, I am trying to use Print To File option to create prn files on a network drive. I added a printer with local port (i.e w:\reports\dailyrep.prn). I want to create a unique file name (not dailyrep.prn) whenever user prints to file. Is this doable in XP? thanks Foxbldr

Hi all, I want to load a pdf file into VFP and print to the printer in the background (without opening pdf viewer). I tried using pdf.pdfctrl.5 but it is crashing at Loadfile method(catastrophic error) Can somebody gimme some clues. Foxbldr

Hi, I am using LeadTools' eprint com server in VFP8. When I used following in my application, I am geeting error. What am I doing wrong? oEprint=CreateObject("lteprintlib.leadeprint") error: class definition "lteprintlib.leadeprint" not found. I regeistered DLLs. Thank you all in advance...

Hi all, I have a Win Xp machine running VFP 6 application that accesses network drives of NT4/Citrix environment. During the execution, the application creates temp files on C drive using FCREATE and opens files (DBFs & other)from mapped drives. Occasionally, I get "error reading file"...

Hi all, I am using follwing sql statement to fetch date from sql server. lcsql="select ......,{ d '1900-01-01' } as TEMP_DT..." when I use following in my code,SOMETIMES, I get operator/operand mismatch error . select lcCursor do while !eof() if TEMP_dt=date(yyyy,mm,dd) && error appears here...

Hi, Can somebody tell how to make folders 'unmovable' so that clients (Win 98, Xp) cannot move folders by using Windows explorer or DOS. Client should have the rights to read/write access to the folder. Thanks Foxbldr

Hi Friends, Within VFP6, I am using Wscript.shell object's run method to run an external program. External program's output is redirected to a text file called output.txt. lcExecStr="abc.exe >output.txt" loShell=createobject('Wscript.shell') loShell.run(lcExecStr,0,.t.) ... My problem is...

Hi Everybody, I want my VFP6 application to monitor a particular folder for some newly created txt files continuously. When I use following code, computer's utilization goes upto 100% level. Can somebody suggest me how to achieve the same without using much resources? llContinue=.t. on escape...

Hi Everybody, I create a CSV file using a cursor and this CSV file is used as an input to some other system. When converting to a CSV file, I want cursor's numeric fields with value zero to be written as an empty string to CSV file. ( I used "Copy to ... type csv") Example: Cursor Code...

Hi All, I have database with about 200 tables and each table has field called 'Rec_status'. When Rec_status is null it is considered as an active record. In order to extract active records from tables, I have to add additional conditions with WHERE clause. Example: Select a.*, b.*, c.* from...