the query and retrieve the value
5. Call this function in the BeforeInsert event of the form.
This will overcome the potential problem mentioned.
--
===
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
Then the end
On Mon, 16 Apr 2001 17:21:16 +1200 AD in comp.databases.postgresql.bugs,
Patrick Dunford said:
>On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general,
>Patrick Dunford said:
>
>>I recently copied five tables to the server using the Postgres ODBC driver
&
On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general,
Patrick Dunford said:
>I recently copied five tables to the server using the Postgres ODBC driver
>with MS Access.
>
>The tables can be viewed in MS Access but not using PHP or Zeos Database
>Explo
ble in ZDO and the column names can be viewed. All the
names of the tables also appear in pg_tables.
Is this a bug in the ODBC driver i.e. it does not make the full entries
needed in Postgres for it to know about tables?
--
=====
n't bother changing the case
and then you are stuck with it :(
--
===========
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
Then the end will come, when he hands over the kingdom to God
the Father after he has destroyed all dominion, authority and
power.
-- 1 Corinthians 15:
the MS Access type representation of what
is on the server, not the server's datatype).
Zeos Database Explorer shows the type of these fields to be "bpchar", is
this a Postgres data type?
--
=======
Patrick Dunford, C
to the hassles you'll encounter if you try
>to do it any other way.
1. Create a sequence
2. Create a ODBC passthrough query to get the NEXTVAL result
3. Write some DAO code to get the result of the query
4. Call the DAO code in BeforeInsert event of the form.
--
========
