Re: [firebird-support] Re: after updates

2014-07-13 Thread slucas slu...@iquanta.com [firebird-support]
hey dmitry, thanx for the advice, i kept digging deeper and i found it in a trigger under the ROPART, but it wasn't the AFTER UPDATE. it was in the BEFORE UPDATE where i had a OLD.something assigned and did that because i used it later in a comparison and i wanted the trigger updated value an

[firebird-support] VS2008 DDEX/ADO.NET confusion

2015-11-27 Thread slucas slu...@iquanta.com [firebird-support]
may someone please give me some clarity? i am using visual studio 2008. i have to use that version to develope an embedded program for a smart device. so i am locked into VS2008. i am trying to find and implement the correct library for fb_client.dll for use on this windows CE embedded devic

[firebird-support] can firebirdsql input/output as json or xml?

2015-12-01 Thread slucas slu...@iquanta.com [firebird-support]
i know this is thinking way outside the box. but is there anyway that firebird can take a pure select statement as a pure string, sent to its 3050 port and then output as a json or xml record or set of records? just curious. wonder what it would take? i know there are web frameworks that c

[firebird-support] access column by column name

2015-12-26 Thread slucas slu...@iquanta.com [firebird-support]
hello one and all, i would like to write a stored procedure which looks something like: CREATE PROCEDURE IC_INITIATE(d CHAR(3), CN CHAR(20)) RETURNS (IC CHAR(22)) AS BEGIN SELECT "CN" FROM TABLE WHERE (DIV = :d) INTO :IC; ...MAYBE OTHER STUFF to IC... UPDATE TABLE SET "CN" = :IC WHERE (DIV = :d);

Re: [firebird-support] access column by column name

2015-12-26 Thread slucas slu...@iquanta.com [firebird-support]
aw, i like that. i've been using firebird/ib for so long i didn't even know that existed. thank you. lucas On 12/26/15 5:18 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: You can use EXECUTE STATEMENT for that. Greetings. Walter. On Sat, Dec

Re: [firebird-support] unsupported on-disk structure

2016-02-04 Thread slucas slu...@iquanta.com [firebird-support]
i just wanted to add to this thread, even if it is a year later. i suddenly had a problem connecting to my firebird fdb files. delphi executables threw back a crazy error about, and i quote it partially, "unsupported on-disk structure for file xxx.fdb; found 32779.16, support , ..." etc. so th