Hi Everyone:

Thanks a million for your solution.  It worked.
Your help was really appreciated.

Thank you once again.

Vibha

-----Original Message-----
From: Godfroy Touglo [mailto:GodfroyT@n...]
Sent: Monday, September 18, 2000 12:02 PM
To: professional vb
Subject: [pro_vb] Re: SELECT Syntax


I don't think that by removing all the ' your sql statement will work.
Whenever you're assigning your sql statement to a variable, put a breakpoint
on the variable and view its content with debug.print. You will get exactly
what your vb code will be processing.
This is how your statement should be:

strSqlStmt = "SELECT d_yr, n_mnl_ver, i_ntm, c_mnl_pg_typ, n_pg, m_file from
dmv00100, dmv00101"
strSqlStmt = strSqlStmt & " WHERE dmv00100.i_mnl_prd = dmv00101.i_mnl_prd"
strSqlStmt = strSqlStmt & " AND c_mnl_prd_acrn = 'CMC'"
strSqlStmt = strSqlStmt & " AND c_mnl_prd_stus = 'C'"
strSqlStmt = strSqlStmt & " AND c_st_alp = '" & strState & "'"
strSqlStmt = strSqlStmt & " AND c_mnl_pg_typ = " & mnl_page
strSqlStmt = strSqlStmt & " ORDER BY d_yr desc"

and when I do:
    Dim strState, strSqlStmt As String
    Dim mnl_page
    strState = "ZZ"    
    mnl_page = 10

the statement variable returned:
SELECT d_yr, n_mnl_ver, i_ntm, c_mnl_pg_typ, n_pg, m_file from dmv00100,
dmv00101 WHERE dmv00100.i_mnl_prd = dmv00101.i_mnl_prd AND c_mnl_prd_acrn 
'CMC' AND c_mnl_prd_stus = 'C' AND c_st_alp = 'ZZ' AND c_mnl_pg_typ = 10
ORDER BY d_yr desc



-----Original Message-----
From: enyonam dayi-kpogli [mailto:mrs_beat@h...]
Sent: Saturday, September 16, 2000 11:03 AM
To: professional vb
Subject: [pro_vb] Re: SELECT Syntax


hi

remove all the comment signs(') before and  then you shd be okay.

regards enyonam


>From: "Vibha Prajapati" <vprajapati@i...>
>Reply-To: "professional vb" <pro_vb@p...>
>To: "professional vb" <pro_vb@p...>
>Subject: [pro_vb] SELECT Syntax
>Date: Fri, 15 Sep 2000 16:58:26 +0100
>
>I am having problem with SQL statement.  Is the syntax correct
>
>strSqlStmt = "SELECT d_yr, n_mnl_ver, i_ntm, c_mnl_pg_typ, n_pg, m_file
>from dmv00100, dmv00101"
>strSqlStmt = strSqlStmt & "WHERE dmv00100.i_mnl_prd = dmv00101.i_mnl_prd"
>strSqlStmt = strSqlStmt & "' AND c_mnl_prd_acrn = 'CMC'"
>strSqlStmt = strSqlStmt & "' AND c_mnl_prd_stus = 'C'"
>strSqlStmt = strSqlStmt & "' AND c_st_alp = '" & strState
>strSqlStmt = strSqlStmt & "' AND c_mnl_pg_typ ='" & mnl_page
>strSqlStmt = strSqlStmt & "ORDER BY d_yr desc"
>
>Thank you,
>
>Vibha
>