Martín Alaimo
|
Posted: 05/03/2001, 5:24 AM |
|
Suppose I have an ORACLE DB with a table called "USERS", which has two
fields: "USR_ID" & "USR_NAME".
Lets say i can get a new ID for a User from a function called GetNewID()
which i place on "modules" section; this function can perform a query to the
DB to obtain a new ID, no matter how (from an oracle sequence or other older
methods)
Then at the event "Before Insert" of the Record form i set "fldUSR_ID =
GetnewID()"
But.. If I hide the field USR_ID then it will be excluded from the Query
Statment.
So... any solution so that i don't have my ID Field exposed?..
NOTE: Remember please, it's a Proyect with lot of maintenance, so we discard
the task of touching the ASP's codes after generation, 'cause there will be
lot's of generations after generation... an so on.
Regards,
Martín Alaimo.
|
|
|
Alexey Alexapolsky
|
Posted: 05/04/2001, 2:38 AM |
|
Do you mean that it's excluded from stemenent when you assign it
"Hidden" type in CC ?
The quick solution is to build your own sql statement right in
CodeCharge , no external code modification is needed ,
just open "Form properties"/Events/Open and assign sSQL variable
your custom statement , like :
$id = get_id();
$sSQL = "insert into table (id,name) values(" . $id . ",'" . $fldname . '")"
where fldsomething is automatically created cc variable for a field named
"something".
--
Regards,
Alexey
CodeCharge Support
Martín Alaimo <malaimo@metaimagen.com> wrote in message
news:9crim9$tim$1@mail.tankhill.com...
> Suppose I have an ORACLE DB with a table called "USERS", which has two
> fields: "USR_ID" & "USR_NAME".
>
> Lets say i can get a new ID for a User from a function called GetNewID()
> which i place on "modules" section; this function can perform a query to
the
> DB to obtain a new ID, no matter how (from an oracle sequence or other
older
> methods)
>
> Then at the event "Before Insert" of the Record form i set "fldUSR_ID =
> GetnewID()"
>
> But.. If I hide the field USR_ID then it will be excluded from the Query
> Statment.
>
> So... any solution so that i don't have my ID Field exposed?..
>
> NOTE: Remember please, it's a Proyect with lot of maintenance, so we
discard
> the task of touching the ASP's codes after generation, 'cause there will
be
> lot's of generations after generation... an so on.
>
> Regards,
>
> Martín Alaimo.
>
>
|
|
|
|