Recent content by CTMHSH

Thank you all for your help. These suggestions put me on the right path to finding the solution I needed. Craig

Hi Thank you but I tired that already, it still has the wrong data in the fields. I have now checked another view and it is doing the same thing. Is there something else I can try (some other VFP command) or might it be an SQL problem when the connection is made and loading the data? Thanks Craig

Hello I am creating a view to download some data from our SQL Server. When I create the SQL View in the VFP program view is rounding my numbers to 2 decimal points. (Example 0.1234 = 0.1200) If I browse the view with the progam off see the data the way it should be. The SQL table fields are...

Hello In a stand alone program I am writing I need to make sure a phone connection or an active ISP is running before I can continue with a part of my program. Is there a command line or SYS() in VFP 6.0 for me to check these for an activity? Thank you Craig

I have gotten this before and have been able to correct it. The problem is I get the 'fatal error' error when the connection is trying to be made. I can go into ODBC Data Source and the connection is made. I am beginning to think it is a VFP thing not SQL. I am able to ping the SQL Server from...

I have a stand alone VFP program that is trying to download info from an SQL Server. I am using "STORE SQLCONNECT('&gcDIALUP', "SH", "SHWIN") TO gnCONNHANDLE" On several PCs this works but on some I get 'Fatal Error C0000005a' and this line of code. I have...