[V4MD] SetField failure

[Ruslan Zasukhin]

on 11/21/03 1:26 AM, Scott Runkel at srunkel at hypix.com wrote:

Hi Scott,

Another advice.

IF you want INSERT some fields as EMPTY, then simply skip them.
You should not send TEXT field to "0" string.

This will eat ONE SEGMENT for each record.
I think you do not want this.

Just do not list TEXT field in the INSERT command.



> on populateTable
> 
> whichYear = 1997
> 
> allText = "0"
> 
> correctAnswer = "A"
> 
> specialty = "1"
> 
> questionMemberName = "test"
> 
> critiqueMemberName = "test2"
> 
> 
> repeat with x = 1 to 250
> 
> sql = "INSERT INTO sa ('year', 'itemnum', 'specialty', 'alltext', 'correct',
> 'memberq', 'memberc') values (" & whichYear & "," & x & ", '" & specialty &
> "',
> '" & allText & "', '" & correctAnswer & "', '" & questionMemberName & "', '" &
> critiqueMemberName & "')"

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------