Appending Records to SQL views 1

[Guntruck]

I have a fully working view with my SQL server. I display the results on a grid. I wish to add a new record to I have a button with just

APPEND BLANK

in it

i then type in values in the grid and when i try to tableupdate() the SQl server says that im trying to insert the value null into a column that cant be null, yet I have typed something into that column... am I just doing something fataly wrong here? I have a irking feeling its not looking to the grid for data its just trying to append a blank row to the server.. where am I tripping up?



Dave

 

[foxdev]

Hmmm...it should be alright, since the INSERT statement isn't actually sent to the server until you move the record pointer or do an explicit TableUpdate; could it be that there are other columns in the table that are not in your remote view or are not in the grid?

You might need to do a trace (either ODBC or SQL Server) to see the actual statement being sent to the server. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[fluteplr]

Look at the update fields in your view. Are they all checked? By default the view designer does not check the key field for update.

 

[foxdev]

Good catch, Fluteplr. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Guntruck]

That was exactly the problem...

thanks.