Home » U++ Library support » U++ SQL » Postgres and CurrVal
Re: Postgres and CurrVal [message #23185 is a reply to message #23138] |
Thu, 24 September 2009 10:42  |
 |
mirek
Messages: 14267 Registered: November 2005
|
Ultimate Member |
|
|
Zbych wrote on Fri, 18 September 2009 04:25 |
luzr wrote on Thu, 17 September 2009 17:26 |
And your opinion about the 'syntax'? Any ideas?
|
Do you mean upp syntax or sql syntax?
Upp syntax (Next() and /) is ok for me. I've made some changes in SqlInsert to support Next() and it works with postgres.
I don't know if SqlInsert should be idiot proof and allow to mix order of columns?
Insert(TABLE)
(COL1, "aaa")(COL2, "bbb").Next()
(COL2, "ccc")(COL1, "ddd").Next() //switched columns
(COL1, "eee"); //one column is missing
|
Well... Maybe we should rather opt for special "MultiInsert" class for this, with different interface...
In any case, there is sort of problem with sql "compiler" internals. Those completely different syntaxes of Oracle and Sqlite3 would make internal representation (using SqlCase) too long, with all values repeated 3 times...
OTOH, maybe this could solve the problem of missing columns..
|
|
|
Goto Forum:
Current Time: Sun Aug 24 14:34:03 CEST 2025
Total time taken to generate the page: 0.04970 seconds
|