Postygresql - izvlichane na serial id field

0 отговора 43 прегледа
#1

Postygresql - izvlichane na serial id field

Zdraveyte,

ako imam ODBC konekciya kam Acess mdb file, ne e problem sled AddNew da
vzema stoynosta ot autonumber pole - "fufa_id":
---------------------------------------------------------------------------
var sql = "select * from fufa";
var rst = new ActiveXObject("ADODB.Recordset");
rst.open(sql, con, adOpenKeyset, adLockPessimistic, adCmdText);
rst.addNew();
rst.Fields("vchar").Value = "This is vchar" + str;
rst.Fields("chr").Value = "buba";
rst.Fields("txt").Value = "This is a text" + str;
rst.Fields("datung").Value = (new Date()).getVarDate();
rst.update();
var generatedId = rst.Fields("fufa_id").Value;
echo("Auto generated id is: " + generatedId);
---------------------------------------------------------------------------

Ako obache ODBC-to e kam postgresql 7.2.1 ne stava i mi se nalaga
da pisha dopalnitelno:
------------------------------------------------------------------------------
// try to get it some other way
var idrst = con.Execute("select currval('fufa_fufa_id_seq')");
if(idrst.BOF && idrst.EOF) {
} else {
idrst.moveFirst();
var id = idrst.Fields(0).Value;
echo("Other way to get it: " + id);
}
idrst.close();
-----------------------------------------------------------------------------
Tarsih v mail listata i namerih

[линк],

tuka choveka pishe che nema problem sled update() da si iztegli
auto poleto????
Imam posledniya driver za ODBC psqlodbc30w.dll versia 07.02.0002
Nyakoy zanimaval li se e s toa problem?

Pozdravi.

Отговор