help with an sql string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jln - 06 Mar 2008 16:57 GMT

What im trying to is when a person logs in it updates the loged_in column for
that person. The code is running but notthing happens.

strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
GID ='" & Environ("username") & "';"

Reply to this Message

Douglas J. Steele - 06 Mar 2008 17:05 GMT

To be honest, I'm surprised you don't get an error, because there are two
mistakes with the SQL.

1) You're not providing a value for Analyst.[Loged_IN] (if it's a yes/no
field, you need Analyst.[Loged_IN] = True)
2) You don't have a space in front of the keyword "Where"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> What im trying to is when a person logs in it updates the loged_in column
> for
[quoted text clipped - 3 lines]
> Analyst.
> GID ='" & Environ("username") & "';"

Reply to this Message

J_Goddard - 06 Mar 2008 17:09 GMT

Hi -

You said "the code is running but nothing happens...". How do you know the
code runs? It shouldn't, because it has an error in it. You have not set
Analyst.[Loged_IN] to a value. Do you have a db.execute strSQL
statement to execute the SQL?

What is in strSQL before you append UPDATE.... to it?

John

>What im trying to is when a person logs in it updates the loged_in column for
>that person. The code is running but notthing happens.
>
>strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
>GID ='" & Environ("username") & "';"

Signature

John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Reply to this Message

jln - 06 Mar 2008 17:18 GMT

Ok i see what your saying so i changed the statement to this.

CurrentDb.Execute "(UPDATE Analyst SET Analyst.[Loged_IN]= yes") & "Where
Analyst.GID ='" & Environ("username") & "';"

>Hi -
>
[quoted text clipped - 12 lines]
>>strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
>>GID ='" & Environ("username") & "';"

Reply to this Message

jln - 06 Mar 2008 17:21 GMT

OK GOT IT

>Ok i see what your saying so i changed the statement to this.
>
[quoted text clipped - 6 lines]
>>>strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
>>>GID ='" & Environ("username") & "';"

Reply to this Message

Allan Smulling - 06 Mar 2008 17:16 GMT

I think you may need to modify the the SET part of the statement. i.e.:

strSQL = "UPDATE Analyst SET <ColumnName> = '" & Analyst.[Loged_IN] & _
"' WHERE GID = '" & environ("username") & "'"

I'm not sure which are you column names but here's the SQL format for
updating:
UPDATE <TableName>
SET <ColumnName> = <Value>
WHERE <criteria>

Hope this helps.

> What im trying to is when a person logs in it updates the loged_in column for
> that person. The code is running but notthing happens.
>
> strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
> GID ='" & Environ("username") & "';"

Reply to this Message