Article View: borland.public.vdbase.data.sql
Article #642Re: datetime
From: Romain Strieff [TeamB]
Date: Mon, 27 Jul 1998 00:00
Date: Mon, 27 Jul 1998 00:00
35 lines
1567 bytes
1567 bytes
In article <35BC28BB.2885@medic.ukm.my>, zag@medic.ukm.my grudgingly admits... > ok, after a few testing, I found this code work: > > to read from informix, I use > > open database informix > set database to > select extract(hour from pptime),extract(minute from pptime),ppdate from > :informix:ptdata ; > where ptid='123456' > > and to write to informix, I use > > set database to informix > update ptdata set pptime='9:45' where ptid='123456' ----- Thanks for the success report. > > I have to switch "set database to infomix and set database to" to make > it work. > Is there any suggestion to make it easy. --- Huh? To make VdB read you mind about which of the possible 1000 database aliases mit any of the possible backend servers you want to use to prevent you from typing these 2 lines into your program? <G> Or just a way to automatically open the informix database when you start VdB? Or something else? -- Romain Strieff [TeamB]
Technical Details
Message-ID:
<MPG.10269751111b4e098b017@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35B82F26.51CA@medic.ukm.my> <MPG.1022a53f15e0f7e698b00e@forums.borland.com> <35B933DB.6B88@medic.ukm.my> <35B97742.C7F2655E@ibm.net> <35BC28BB.2885@medic.ukm.my>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e9971370cc8cf784 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: datetime Date: 1998/07/27 Message-ID: <MPG.10269751111b4e098b017@forums.borland.com> X-Deja-AN: 375289142 References: <35B82F26.51CA@medic.ukm.my> <MPG.1022a53f15e0f7e698b00e@forums.borland.com> <35B933DB.6B88@medic.ukm.my> <35B97742.C7F2655E@ibm.net> <35BC28BB.2885@medic.ukm.my> Organization: TeamB Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql