Query Parser

Results 1 to 2 of 2

Thread: Query Parser

  1. #1
    Join Date
    Dec 1969

    Default Query Parser

    Greetings Gurus,<BR><BR>I&#039;m looking for a script or component, or at least some guiding advice, to help me with parsing an SQL query into parts. What I need is to be able to grab the table name and where clause from a SQL statement. <BR><BR>I&#039;ve played around a bit in VB with doing this, but everything I&#039;ve tried is big and clunky.<BR><BR>Anyone know if there is anything already out there?<BR><BR>Thanks,<BR>Neils Christoffersen

  2. #2
    Join Date
    Dec 1969

    Default RE: Query Parser

    Not sure what you&#039;re asking.<BR><BR>strSQL = SELECT * FROM tableName WHERE field = var"<BR><BR>and you want the tablename from this string? Some simple string manipulation will do I guess. Check the MID and Instr functions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts