INSERT not working

[Chuck Neal]

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.com
http://www.mediamacros.com
http://www.mediamacros.net


Ruslan Zasukhin wrote:
> On 2/28/06 3:33 PM, "Chuck Neal" <chuck at 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.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
>