Recent content by foxbldr

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