On 11 Sep 2016, at 10:48pm, mikeegg1 wrote:
> I think Oracle (a long distant memory) has variables like @variable or
> @@variable where you can do something like '@variable = select rowid from
> table where field = 4' and then later do 'insert into othertable (field2)
>
I think Oracle (a long distant memory) has variables like @variable or
@@variable where you can do something like '@variable = select rowid from table
where field = 4' and then later do 'insert into othertable (field2)
value(@variable)’. Does this make sense? I’m wanting to in the shell select
On 11 Sep 2016, at 10:53pm, mikeegg1 wrote:
> Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I
> can fully access last_row_id().
It's not a C function, it's a function you can use inside SQL commands. There
shouldn't be a problem with it.
I forgot I could use it inside the shell. Thanks.
Mike
> On Sep 11, 2016, at 16:58, Simon Slavin wrote:
>
>
> On 11 Sep 2016, at 10:53pm, mikeegg1 wrote:
>
>> Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I
>> can fully
You can also access that value within your Perl code, in a DBMS-agnostic
fashion, with the appropriate DBI routine:
http://search.cpan.org/dist/DBI/DBI.pm#last_insert_id
-- Darren Duncan
On 2016-09-11 2:59 PM, mikeegg1 wrote:
I forgot I could use it inside the shell. Thanks.
On Sep 11,
Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I
can fully access last_row_id(). :)
Mike
> On Sep 11, 2016, at 16:52, Simon Slavin wrote:
>
>
> On 11 Sep 2016, at 10:48pm, mikeegg1 wrote:
>
>> I think Oracle (a long
MyJSQLView Version 7.08 Released
The MyJSQLView project is pleased to release v7.08 to the public. The
release marks a complete code review and cleanup. Updated libraries have
also been included with this release along with the Table Field Profiler
plugin. There have been many fixes in this
On 9/10/2016 1:16 PM, Olivier Mascia wrote:
Le 10 sept. 2016 à 11:21, Alexander Täschner
a écrit :
since upgrading to Windows 10 I have trouble with several different C#
programs I wrote, that uses System.Data.SQLite to access sqlite
database files
...
The
On Sat, 10 Sep 2016 13:31:51 +0100
Simon Slavin wrote:
> You do it after opening a connection to the database. Probably the
> first thing you do after sqlite3_open().
Thanks!
--
73 de HA5OGL
Op.: Levente
9 matches
Mail list logo