Mike Yearwood
Toronto, Ontario, Canada
General information
Title:
GATHER NAME vs APPEND
Hi all
I've run an SQL command. I want to add those records to a table. I use APPEND FROM. If there is a field in the SQL result that has a value bigger than the corresponding field in the table, I don't get an error message. The value of that field will be *.**.
If on the other hand, I want to update existing records from the SQL result, I could do this...
SELECT c_Result
SCAN
SCATTER NAME loScatter
SELECT TheTable
GATHER NAME loScatter
ENDSCAN
The bigger SQL field will generate a Numeric overflow error. Why does it not just behave like the append?
The error message does not say which property or field has the problem. I believe VFP should name the first field with a problem.
One other thing. SQL Server 7 allows for this...
UPDATE TheTable SET ;
Field1 = c_Result.Field1 ;
FROM TheTable, c_Result ;
WHERE TheTable.PK = c_Result.PK
Is there a way to use VFP's UPDATE - SQL to update all TheTable records from c_Result?
Thanks!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only