Search results for query: *

dbMark, Thanks for the reply. My app is written in VFP6. Foxbldr

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

ML, I had a similar situation and I was asked same type of 'What-if' questions from the client. In my case, I used a simple binary file to bypass security and grant admin rights to the user (i.e.Chief Info. Officer/Owner) with an expiry time. Binary file is created by the user (creation will...

Thank you for keep posting. Baltman: Fopen returns a value greater than 0 when checked with 8.3 file name. Ed: No, there is no effect with EXACT ON/OFF here. I don't have this issue with files on local drives so look like I need to talk to network gurus in the company. Foxbldr

Ed, Though I didn't mention with earlier post, actually FILE() is used as follows: if File(addbs(m.tcDynamicDataPath)+ m.tcDailyRunFile).. which look like: if File("G:\PS\GLPosting\Trading\dt060817_P_L.dbf").... Foxbldr

Ed, An app written in VFP6 creates these DBFs using flat files daily. Scary thing is that I am developing another system that uses these daily files (ie daily posting..) to feed an accounting system. Process need to be automated and checking existance of files needed as the process should skip...

Ed, Yes, it's Novel Client Version 4.83 SP2 on NT. I know that FILE() search for the file in SET PATH paths but these files are created daily in one location only. I had a search too. Tx _Foxbldr

Thanks for quick replies! Ed: When I browse the file on server what I see is file names longer than 8.3. At the same time explorer (with NT) shows 8.3 files names in separate column. i.e. long name 8.3 name DT060815_P_L.dbf DT060815.dbf DT060815_P_S.dbf ...

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

1001011010, Use Crystal Report Object and use Printout method. i.e. OCrysralRpt.Printout False Foxbldr

RonRepp, Yes, you are right! Usage of Array was giving me troubles. Thanks -Foxbldr

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

Skip: I am changing code behind a large excel book which extracts data from Ms Access 97 queries. ActiveSheet.QueryTables.Add(Connection:= _ "FINDER; T:\sql_queries\prod\DailyTran.dqy",.... Management wants to get rid all Ms Access DBs but want to keep all excel workbooks and...

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 Baltman, Is Wordnum function availbale with VFP6? Rgds Foxbldr

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 BB, Thanks for your suggestion and that method eases most of subsequent coding in my project. 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 Mike, When checked with AERROR, time to time, I got different errors. i.e. The specified C:\...\...\get_month_sum library could not be loaded. (get_month_sum is my DB2 stored procedure.) and sometimes, DB2 sqlstate codes. My connection is OK and sqlexec works fine with select statement...