[thelist] Creating MS Access tables in CF

[rudy limeback]

> 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