[thelist] Creating MS Access tables in CF
rudy limeback
r937 at interlog.com
Thu Jul 13 00:15:13 CDT 2000
> create table #form.tablename#
> (columnname datatype,
> etc);
>
> Never needed to try this before, but it might work.
> Rudy will correct me if I'm wrong.
hi isaac
i was gonna let this go completely unanswered, which is kinda what you
asked for ;o)
haven't done it myself but i have heard of it being done, yes you can pass
access a create table statement through a web page
<tip>
i had to dig this out for somebody else today so i thought i'd pass it on
here, copyright be damned...
microsoft access has syntax which is definitely out in left field, here for
example are the specs for the access wildcard characters, taken from the
access 97 help file --
* Matches any number of characters. It can be used as the
first or last character in the character string.
example: wh* finds what, white, and why
? Matches any single alphabetic character.
example: B?ll finds ball, bell, and bill
[ ] Matches any single character within the brackets.
example: B[ae]ll finds ball and bell but not bill
! Matches any character not in the brackets.
example: b[!ae]ll finds bill and bull but not bell
- Matches any one of a range of characters. You must
specify the range in ascending order (A to Z, not Z to A).
example: b[a-c]d finds bad, bbd, and bcd
# Matches any single numeric character.
example: 1#3 finds 103, 113, 123
Notes
~ Wildcard characters are meant to be used with text
data types, although you can sometimes use them
successfully with other data types, such as dates,
if you don't change the Regional Settings properties
for these data types.
~ When using wildcard characters to search for an
asterisk (*), question mark (?), number sign (#),
opening bracket ([), or hyphen (-), you must enclose
the item you're searching for in brackets. For example,
to search for a question mark, type [?] in the Find
dialog box. If you're searching for a hyphen and other
characters simultaneously, place the hyphen before or
after all the other characters inside the brackets.
(However, if you have an exclamation point (!) after
the opening bracket, place the hyphen after the exclamation
point.) If you're searching for an exclamation point (!)
or closing bracket (]), you don't need to enclose it in
brackets.
~ You can't search for the opening and closing brackets ([ ])
together because Microsoft Access interprets this combination
as a zero-length string.
~ If you're searching for values in a table other than a
Microsoft Access table, such as a Microsoft SQL Server table,
you may need to use different wildcard characters. Check the
documentation for that data source for more information.
</tip>
rudy.limeback
r937.com
evolt.org
More information about the thelist
mailing list