Recent content by jayfox

Has anybody ever seen this error before? Foxcode table not found, is not correct version or is incompatible Error 111 Cannot update cursor 'client', since it is read only method: load line: 9 Please help!

I distributed the app,on a different machine, using a setup program created by installshield. When I sign the exe runs fine. WHen a use sign on I get the error 111. How do I know if the file is readonly?

Help - I distributed an app and I can't get it to work on user's machines. The error that I get is Error 111 can not update the cursor since it is read only. The table is not read only. If I log in to the machine and run it the exe runs fine.

Hello all - I have two servers one called Hamlet with windows 2003 and I have a buffalo terastation (don't laugh). Everything is getting backed up, but I still get a list of errors. 1. Backup- Hamlet V-79-57344-33928 - Access is denied. Acess denied to directory. Access is...

We compress our database files each night (in RAR format), then FTP them down to one of our servers at a different location. Generally the database files were about 800 megs. They have suddenly doubled in size the last few days. I am not sure what is going on. Any ideas? Thanks

It does not like the second select. Server: Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'select'. Server: Msg 170, Level 15, State 1, Line 14 Line 14: Incorrect syntax near ')'. Can you have two selects ina row like that?

Thanks I'll give it a try

Sorry I left out admitdate on table should be included

If I have two tables Table A: ID IOL Voced 1234 NULL NULL Table B: ID IOL Voced AdmitDate 1234 1 Null 7/1/2005 1234 2 3 7/3/2005 1234 Null NUll 7/5/2005 I would like to...

Damn! I thought that would work but it didn't.

When I run this I do not get errors but no report displays either. Also if I choose a report that requires a paramter then the parameter screen will display but when I hit OK the report again does not display...I can't figure this out. Any help would be great. Here is my code: Dim crysApp As...

I access a remote server with pcanywhere in which sql server resides on that server. I just loaded vis fox on my machine how can I access sql server on the remote machine?

I understand how to create the DTS my problem is getting the header record to be included in my text file every time I run the DTS. Would I have to create a seperate table that holds my header record than insert my results into this table. Then execute the DTS?

I have a query that needs to be exported to a tab delimited file it alson needs to include the column headers. Everything is fine until I found out I need to include a header everytime which also needs to be tab delimited. How can I go about doing this with a DTS. Should I go about it a...

Thanks sqlsister