Dawn Oakes wrote:
Well, The SYS_COLUMNS table contains SYS_TYPE_NAME. So you could try:
SET VAR vdatatype = SYS_TYPE_NAME in SYS_COLUMNS WHE SYS_COLUMN_NAME = chosencolumn.
IF vdatatype = 'TEXT' then set var vdata = (''' + .vdata + ''')
ENDIF
Haven't tried it, but it makes sense to me.<g>
-----Original Message-----
From: Les Stark [mailto:[EMAIL PROTECTED] Sent: Monday, February 14, 2005 2:10 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - A function to determine a fields format?
I'm sure the must be a simple answer so...
I have an .eep that uses several Choose and Dialog commands to allow
users to pull up selected rows of data for any tables or fields in the
database. It assembles a set of variables that are put into a Browse
command. This would be similar to the old Prompt by Example in 3.
Rbase. The problem is the user must know what are text fields so he can
enter apostrophes around the text field dialog. Is there a function
that will give me an indicator if the filed is text or integer? I know that the user could just use the tabular browse view and its
included commands but a step by step Choose with Dialog entries is
simpler for the casual user.
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/05
Thanks Dawn, I was sure it was simple, but couldn't seem to wrap it up.
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/05
