No error code. I put the Xtra in function reporting and it shows the
execute and even says done. No error, etc but the rows effected returns
void. Not 0, just void. I have checked and rechecked to make sure I am
using the correct types, traced the code, and even manually entered the
inserts in the message window. The same query works in studio. The only
difference in the tables I see is that the one that fails has number
fields (ULong)
-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros DO.T com
http://www.mediamacros.com
http://www.mediamacros.net
Ruslan Zasukhin wrote:
> On 2/28/06 3:33 PM, "Chuck Neal" <chuck@mediamacros.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 at domain DO.T 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
>
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Chuck Neal |
