Filemaker 6, Serial number and ODBC #2

  • Permalink
  • submit to reddit
  • Email
  • Follow


Hi all,

I'm inserting into a FM6 table via ODBC, and the table has a
non-modifyable serial number (auto-entered).

any idea how i can get the value of that column for the record i just
inserted?

Thanks
Andy

0
Reply ajohnstone (24) 6/22/2005 4:01:49 PM

See related articles to this posting


Just put the serial-number field on your layout. Or isn't that what you 
need?

Ursus

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119456109.758033.19970@g14g2000cwa.googlegroups.com...
> Hi all,
>
> I'm inserting into a FM6 table via ODBC, and the table has a
> non-modifyable serial number (auto-entered).
>
> any idea how i can get the value of that column for the record i just
> inserted?
>
> Thanks
> Andy
> 


0
Reply ursus 6/22/2005 9:11:20 PM

ursus,

I'm accessing soley through ODBC... so no layouts involved.

What i did is basically the equivolent of the @@IDENTITY variable in
SQL Server.

I *could* do the insert, and then Select Max( ID ) FROM table... but
i'm not sure that guarantees me the ID of the row I just inserted (as
opposed to a row inserted *after* my insert, but *before* my select).

Hope that clears what I'm looking for up a bit.

Andy

0
Reply Andy 6/23/2005 12:59:10 PM

I am absolutely a nitwit regarding ODBC. But what I gather is that you want 
to see a value inside FMP before through a ADBC connection. I don't think 
that would be possible.

have you tried the FMP helpfile? it has some info on how to use OBDC. This 
is the list of instructions and elements that FMP can handle. It sdoesn't 
mention the @@IDENTITY. But as I don't know anything about OBDC I could be 
talking rubbish.

SELECT
INSERT (ook in een subopvraag)
UPDATE
DELETE
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE INDEX
DROP INDEX
FROM-instruction
ORDER BY-instruction
GROUP BY-instruction
HAVING-instruction
WHERE-instruction
UNION-operator
FOR UPDATE-instruction
: SUM, AVG, COUNT, MAX, MIN
DISTINCT SQL-operator
Inner Join-instructions
Left Outer Join-instructions
Subopvragen
Scalaire instructions
Current of Cursor-instructions
ROW ID

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119531550.117832.207040@g43g2000cwa.googlegroups.com...
> ursus,
>
> I'm accessing soley through ODBC... so no layouts involved.
>
> What i did is basically the equivolent of the @@IDENTITY variable in
> SQL Server.
>
> I *could* do the insert, and then Select Max( ID ) FROM table... but
> i'm not sure that guarantees me the ID of the row I just inserted (as
> opposed to a row inserted *after* my insert, but *before* my select).
>
> Hope that clears what I'm looking for up a bit.
>
> Andy
> 


0
Reply ursus 6/23/2005 1:21:41 PM

ursus,

Yes, I've looked through the help, and haven't found what I need, which
is why I'm asking here if and how it can be done.

The best I could do is a select immediately after the insert.. but I'm
not sure that would ensure I have the row i inserted, and not someone
else.

Thanks
Andy

0
Reply Andy 6/23/2005 2:10:11 PM

If you use a log-in system for your fmp file,  (accounts & privileges) you 
could do the following.

Create a script that
Imports your original ODBC record-serial-number together with all the data 
you need for the record
then puts the original ODBC record-serial-number into a global field.

With a user based system, globals are user-specific. So gMyGlobal can hold a 
value of UrsusSerial on my console (computer in the network) and at the same 
time hold a completely different value AndysSerial on your console. This way 
you will allways know what serial came out of the ODBC connection and that 
you are the one that put it there in the first place. Be aware that normally 
globals are stored when you shutdown a file. But with multi-user systems 
only the last one gets stored. But then again you should almost never rely 
on globals to hold data that does change to be retrieved in a new session.

Ursus

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119535811.102568.265530@f14g2000cwb.googlegroups.com...
> ursus,
>
> Yes, I've looked through the help, and haven't found what I need, which
> is why I'm asking here if and how it can be done.
>
> The best I could do is a select immediately after the insert.. but I'm
> not sure that would ensure I have the row i inserted, and not someone
> else.
>
> Thanks
> Andy
> 


0
Reply ursus 6/23/2005 4:13:09 PM

Why don't you create a unique ID in your SQL database and send that to
FileMaker along with the other information. Then when you wanted to get
FM's unique ID, you could do

SELECT filemakerID FROM Table WHERE sqlID = 'known ID'

When you're synchronizing between two databases, it's a commonly used
technique to have a different unique identifier for each one that you
replicate on both sides. This has added benefits, such as the ability
to tell if a record has been synchronized (look to see if both ID
fields are populated). 

Kevin

0
Reply audleman 6/23/2005 5:01:50 PM

Kevin & ursus,

Sorry, I think I created more confusion then I cleared :-)

I don't have any other DBs right now.. FM6 is the sole database
provider, I'm just writing an application to be a front end to the
database..

I threw out the @@IDENTITY from SQL server just to ask if there's
anything similar in FM ODBC, since thats basically the functionality
I'm looking for.

Andy

0
Reply Andy 6/24/2005 2:40:48 PM
comp.databases.filemaker 10774 articles. 18 followers. Post

7 Replies
499 Views

Similar Articles

[PageSpeed] 44


  • Permalink
  • submit to reddit
  • Email
  • Follow


Reply:

Similar Artilces:

Filemaker 6, Serial number and ODBC
Hi all, I'm inserting a record via ODBC into filemaker and the table has a AutoEnter Serial that can't be modified. After I do the insert, I'd like to find out what the serial number was assigned to, so that I can continue working with it (or insert related rows). In SQL Server I have @@IDENTITY, anything similar for filemaker? Thanks Andy ...

[wxGTK 2.6.1 Gtk+ 2 Debian Sarge 2.6] ODBC problems
I compiled wxGTK to use system iODBC driver, and I want to connect to Postgresql database. Connecting to postgres with iodbc manualy works, but when I try to connect with an example wxWidgets program I get a strange error: TABLE CREATION ERROR: ODBC errors: SQL State = 01S02 Native Error Code = 16 Error Message = cursor updatability changed As far as I can tell it connects to database, but then something goes wrong :( Anyone know how could I fix this? Source code is from documentation with small modifications: // -----------------------------------------------------...

Serial port---vxWorks 6.6 #2
Hi I am using vxworks 6.6 workbench 3.0. our bsp supports 2 serial port but v need 4 serial ports to b enabled I made the following changes in the BSP N_UART_CHANNEL --4 in pc.h file. In sysSerial.c I made entry for all the four ports . Note: I use the same procedure for vxworks 6.4..Its working fine. Thanks in Advance Regards, Papi ...

[wx 2.6.2]
------=_NextPart_000_001E_01C64812.96E29240 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hello, any standard cross-platform (wx) way to do serial communication under Windows and Linux? Alfonso ------=_NextPart_000_001E_01C64812.96E29240 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC...

Does anyone know the serial number for realpro-2.2 by CoGenTex
RealPro Syntactic Realization Framework Evaluation Edition, Version 2.2 for English developed by CoGenTex, Inc I have downloaded realpro-2.2. But this java program does not run without a serial number. I have sent several emails to cogentex to apply for a serial number. But I have not received any reply so far. So does any one know the serial number of realpro-2.2(for evaluation purpose only) ? Thanks in advance! ...

Serial Device Driver architecture changs from 2.4 to 2.6?
Hi, Can anyone please point to me a place/url where I can find the basic architectural changes for the serial drivers between 2.4 and 2.6 kernels? It used to be a single serial.c file under drivers/char but now there are around 40+ files under drivers/serial directory. Is there any document/readme which gives any info on this new architecture (break-up)? Thanks in advance. Your help in this regard is highly appreciated. regards, Ravi. ...

Serial number #2
i want to generate a number that is unique for a machine.I decided to get hdd serial. But i have to find more than that.which hardware numbers can i take? how? tardas wrote:> i want to generate a number that is unique for a machine.> I decided to get hdd serial. But i have to find more than that.> which hardware numbers can i take? how?Please do not multi-post (the placement of the same message independently in multiple newsgroups). It fragments the thread and frustrates folks who are trying to help you.If you absolutely feel the overwhelming need to reach multiple groups, which you ...

serial number #2
hi all how can i have my flash memory or drive serial number? thank you On 3/12/2012 4:54 AM, siamanesh wrote: > hi all > how can i have my flash memory or drive serial number? > thank you the serial number is normally located on the back or below the drive itself. On a sticker. So, Just turn the memory stick or the disk to its side and look below it, you should be able to find it. --Nasser On Monday, March 12, 2012 10:54:13 PM UTC+13, siamanesh wrote: > hi all > how can i have my flash memory or drive serial number? > thank you With fries please. "siamanesh&q...

ODBC lock Problem Btrieve 6.15 and Pervasive ODBC Driver 2.x
hello, first my english is bad. i have write a windows application that connect via pervasive odbc 2.x to a btrieve 6.15 database, when the application is startet from 5 pc the 6 start from pc 6 don't work, the btrieve tabel or database is locked? have btrieve 6.15 via odbc a conenction limit of 5 user ? can i set a higher max connection? is the odbc driver the limit? greetings js There was a special "Developer" version of Btrieve 6.15 that some developers incorrectly sent to their customers. The Developer engine had a limit of 5 users in it. You should be able to ch...

Device Serial Number #2
It is easy for me to get device (for example: tape drive) S/N on AIX: lscfg -vpl rmt10 rmt10 U7879.001.DQD01HM-P1-C2-T1-W50=AD050763004E770B-L0 IBM 3580 Ultrium Tape Drive (FCP) Manufacturer................IB=ADM Machine Type and Model......ULT3580-TD2 Serial Number...............111006303=AD1 Device Specific.(FW)........47Q0 I searched in this group, no luck. Can anyone tell me know to get device S/N on SUN Solaris and HP-UX? TIA In article <1117564584.850276.118780@g44g2000cwa.googlegroups.com>, <Weiduo.Deng@gmail.com> wrote...

ODBC Filemaker 6 Unlimited
Hi all, I'm having a problem where Sql sent to FM through ODBC is causing the program sending the Sql to shutdown. The query is: SELECT * FROM TABLE WHERE ID = 235 OR ID = 256 It would seem simple, but its not. MS Query does something to the Sql it sends before it sends it, so it seems to work (although entering that exact sql to send in MS Query causes it to close as well). Any ideas as to why such a simple thing would cause such problems? Thanks Andy In article <1123161258.095439.112610@g14g2000cwa.googlegroups.com>, ajohnstone@capcitypress.com says... > Hi all, > ...

Spectrum serial numbers #2
Can anyone point me to or even tell me somthing about the serial numbers on spectrums. ie if I have a green serial number etc Cheers In news:440b63e6$0$4589$c3e8da3@news.astraweb.com, del@here.com <del@here.com> typed: > Can anyone point me to or even tell me somthing about the serial > numbers on spectrums. ie if I have a green serial number etc Most of the serial numbers were white, but you occasionally got some in red, green, yellow and blue - it depends what the stationers down the road near Sinclair were doing a bargain run of. D. > Most of the serial numbers we...

odbc drivers in 2.6
This may have been covered before but a NG search didn't help. Going through the SSA example/tutorial requires an ODBC connection to a dbf. The docs go through the installation process for adding CA ODBC drivers. This is not working. I can still see only MS drivers after "installing" from the VO2.6 cdrom. Something's missing. Any help would be appreciated. THX IanH Ian! See this: http://groups.google.co.hu/groups?q=K%C3%B6rm%C3%B6ndi+group:comp.lang.clipper.visual-objects&hl=hu&lr=&ie=UTF-8&inlang=pl&group=comp.lang.clipper.visual-...

FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDe
FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other ... FileMaker Server 7 (26/Oct/2004 Filemaker Developer v7 WinALL Mac SN:3V294-57K77-8TKNX-7K26K-228K9-13T33-X29T9 CD NR 15 792 Clarion.v6.0.Enterprise.Edition.Incl.Keygen.WinALL (wee...

FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDe
FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other ... FileMaker Server 7 (26/Oct/2004 Filemaker Developer v7 WinALL Mac SN:3V294-57K77-8TKNX-7K26K-228K9-13T33-X29T9 CD NR 15 792 Clarion.v6.0.Enterprise.Edition.Incl.Keygen.WinALL (wee...

FileMaker Server 7, Filemaker Developer v7 WinALL Mac, IBM VISUALAGE FOR COBOL V3.0.6, Fujitsu NetCOBOL Suite v7.0L10 Enter. Edition, Intel Fortran Compiler Pro With IMSL V8.0.048, Clarion.v6.0 #2
FileMaker Server 7, Filemaker Developer v7 WinALL Mac, IBM VISUALAGE FOR COBOL V3.0.6, Fujitsu NetCOBOL Suite v7.0L10 Enter. Edition, Intel Fortran Compiler Pro With IMSL V8.0.048, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MICROSOFT VISUAL STUDIO NET PROFESSIONAL 2003, MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other ... FileMaker Server 7 (26/Oct/20...

ASK http://cam.to/crack-cad/ 3050 RECENT CAD/CAM/CAE/GIS/ PTC PRO ENGINEER WILDFIRE V2.0 M0100 -CD2 , _ crack, serial, fix, patch, license, free, download, Fluent 6.1.18 Gambit 2.0 Airpak 2.06 , ANSY
ASK VIA http://cam.to/crack-cad/ 3050 RECENT CAD/CAM/CAE/GIS/ AND PCB/3D PROGRAM WITHOUT PROTECTION. DOWNLOAD FREE REAL CDS-CATALOGUE. RECENT UPDATE 20 December 2004 (RECENT UG, CATIA, ANSYS, SAP2K, PRO/E, PRO/MECHANICA, MASTERCAM, ROBOT, STRUCAD, SDS/2) AND MANY OTHERS. ATTENTION about HONESTY !!! HOW AVOID CHEATERS ??? MANY CHEATERS OFFER SERVICE IN INTERNET (Belarus, China), BUT ONLY HERE YOU CAN GET REAL PROGRAMS WITHOUT FRAUD, BECAUSE WE HAVE REAL CD-catalogue CONTACT US via http://cam.to/crack-cad/ (my e-mails) (please connect with internet without proxy of yo...

2 Problems with FileMaker and PHP over ODBC
hello, I need your help because the filemaker support in europe and the filemaker support in us don't answer my questions. I have 2 problems: 1/ The performance from the odbc driver is very poor. A simple SELECT statement like "SELECT country FROM countries" need around 30 seconds before I see the result. The countries table have 58 entries. If the countries table have more than 70 entries i became an: Fatal error: Maximum execution time of 30 seconds exceeded... We use an Windows 2000 Server with php 4.3 and Filemaker 7 Advanced Server. You can see the test page at: http://www...

Download without serial number #2
Internet download manager programme without serial number it is free You can install free not need any crack or serial number http://sharecash.org/download.php?file=2900929 ...

Serial number after inserting via ODBC
I'm using FM Server 8 Advanced, and I'm connecting to it through ODBC (using ASP and ADO). Everything is working fine, except for two problems: - it's PAINFULLY SLOW - I haven't found a way to read back the generated auto-enter serial number after inserting a record I insert records through a recordset (using the AddNew and Update methods). With other database systems, I can read back the auto-generated fields after calling Update, but with FM it doesn't seem to work. Also there is no feature similar to @@IDENTITY from SQL Server. Is it possible to reliably get the auto-en...

Req: Serial Number for Filemaker Recruiter
Request Filemaker Recruiter Serial Number Version 1 or 2 it really does not matter. Thanks in advance for your help In article <fssk325q6l2rq2d0ca6jcoqpp6l7dhqtdt@4ax.com>, eholley@intgmail.com wrote: > Request Filemaker Recruiter Serial Number Version 1 or 2 it really > does not matter. Thanks in advance for your help Pay for it like everyone else does you selfish idiot. :o\ Helpful Harry Hopefully helping harassed humans happily handle handiwork hardships ;o) ...

NS records and serial numbers #2
A few questions: - If a domain name has 3 nameservers, does the zonefile *have* to=20 have all 3 listed as: IN NS ns1. IN NS ns2. IN NS ns3. I ask because some of our zonefiles on some nameservers do not=20 list all 3 (We added a 3rd nameserver but some old records did not=20 get updated). What problems could this cause? - If using 3 master nameservers for 1 domain, does the serial=20 number have to be the same on all 3 nameservers, or is it=20 namserver specific? Thanks Rob ...

maya 6.5 serial number
i�ve just downloaded maya 6.5 but i can�t find a serial number If it didn't come with your download, just e-mail prosecute.me@alias.com for a free one. They'll be more than happy to help Equinox "lichtquanta" <lichtquanta@yahoo.com> wrote in message news:d50aa6d648c3a2fca4994c8124eb0cf2@localhost.talkaboutanimation.com... > i�ve just downloaded maya 6.5 but i can�t find a serial number > Alias Maya Unlimited v6.5 MACOS, Windows, Linux, IRIX, MASTERCLASSES 2004, Animating, Raytracing, Rendering, Gnomon Maya stuff and Addons, ARTBEAT...

RE: Storing of Serial Number #2
Which manual will tell me more about sequences ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Art S. Kagel Sent: 08 March 2005 12:52 AM To: informix-list@iiug.org Subject: Re: Storing of Serial Number nobody wrote: > > > Art S. Kagel wrote: > >> Andrew Hamm wrote: >> >> Well put Andrew. There is NO defensible<SP?> reason to peak at the >> next serial value in application code. The practice is a recipe for >> disaster. >> >> Art S. Kage...