🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #642

Re: datetime

#642
From: Romain Strieff [TeamB]
Date: Mon, 27 Jul 1998 00:00
35 lines
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-mail
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>

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