On 2/28/06 3:33 PM, "Chuck Neal" <chuck (at) mediamacros .D.O.T com> wrote:
Hi Chuck,
> Using version 2.2 of the Director Xtra...
>
> I have a database that is not accepting some inserts. If I open studio
> and execute a query it inserts the values.
> If I open Director and execute a query with a list of values it works if
> all the fields are varchar.
> if I have a field that is a Long it does not work.
> The execute command returns 1 on the tables that are all varchar.
> On the tables that have a long or other number it returns void
> for the execute command.
> These same functions were working 2 weeks ago on the previous version of the
> Xtra.
>
> If I manually insert the record in studio then it will delete the record with
> the execute command.
> For the test I use this...
> INSERT INTO userData (userName, email, idNumber) VALUES(:1, :2, :3)
> ["Test", "test@domain.com", 5]
>
> Any ideas what is throwing it? Is there some new permission or
> something that changed between 2.1 and 2.2 I need to know about?
Does it return any error code ?
I have add new function SqlQuery() but as I remember I did not touch existed
code..
We need try to reproduce
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
Valentina mailing list
Valentina (at) lists .D.O.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Ruslan Zasukhin |
