help: var not updated on text

Abstracto · **Joined:** January 25th, 2005, 11:53 am **Posts:** 9

Hi

I having some problems with some variables.
I get some variables from a database record.

Code:

function GetData()
{
   RecSet = db.ExecuteSQL("SELECT * FROM PROJECT WHERE (CODPRO = "+db_codreg+");")
   RecSet.FirstRecord()
   RecSet.FirstRecord()
   db_nompro    = RecSet.NOMPRO
   db_nom2pro    = RecSet.NOM2PRO
   db_idepro   = RecSet.IDEPRO
        .....
}

With Debug.trace, i can see this vars are gettin correct values,
but these vars (db_nompro, db_nom2pro,db_idepro...) are not updated on a text control.
I have added these vars as page vars, and added them on the text control using the "Insert variable or expresion" option

Im running the script on the page OnShow event (i have tried also the PreShow, but same )

Any solution?

I think this is a naughty bug on Opus ( im using Opus 4.5 pro).
Any help?

Jason · **Joined:** June 29th, 2005, 9:39 pm **Posts:** 9

You might want to try creating new variables with new names and try it with them. I've run into problems previously where variables get corrupted and behave the way you've described. Deleting the corrupted variable and readding them doesn't seem to help either.

Jason

Digital Workshop

help: var not updated on text

Who is online