U++ framework
Do not panic. Ask here before giving up.
Home » U++ Library support » U++ SQL » Trouble Adding rows to SqlArray
Re: Trouble Adding rows to SqlArray [message #20316 is a reply to message #20315] Mon, 09 March 2009 13:24 Go to previous messageGo to previous message
mirek is currently offline  mirek
Messages: 14291
Registered: November 2005
Ultimate Member
bianconejo wrote on Mon, 09 March 2009 07:08

Hi Mirek

Thanks again !!!


I tried the AddCtrlAt / StartInsert all seem to run well :

* when invoking StartInsert a new line is appending at the end of my SqlArray

* Controls linked to the Array with AddCtrlAt seem to "insert" the new values in the new array line ...

...but, the key column is the only one to remain empty.

For now, Reading and Updating from the gui to the DataBase is OK but creating a new line in the DB is quite problematic...

I tried to alter the definition of the array with AppendingAuto and then AutoInsertId ( I thought it could have get a primary key for the new row) but I got a Sql Error (two ID insertion attempt).

Do you have an idea to get this SQL insertion running ?





Unfortunately, this depends on DB choosen. For PGSQL or Oracle, I recommend using sequence and use it with InsertValue.

Mirek

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Compacting an MS-Access db
Next Topic: PostgreSQL example does not save data to database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu Sep 10 01:13:56 GMT+2 2026

Total time taken to generate the page: 0.00889 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software