Cetin: Hello!

I understood your message completely. Your comments made a lot more sense to me this time. Sometimes it takes two times, but I'll get it!

One thing did trip me up a little bit, and I want to show you what that is. Maybe you can catch something in my code that is causing an error message.


When I go to my view designer and copy my SQL statment to paste into the combo.init(), I get an error message that tells me I have incorrect syntax.

In the .init() of my combo I have placed the following code:

lcSQL = %SELECT * ;
FROM voices!voterfilefields INNER JOIN voices!fielddetails ;
ON Voterfilefields.nfieldid = Fielddetails.nfieldid ;
WHERE Voterfilefilds.cfieldcategories = "Identifier" ;
AND Voterfilefields.cfieldfilestate = ?thisform.currentstate ;
ORDER BY Votersfilefields.cfieldlabel ;
"into cursor Cursor5"%

this.rowsourcetype = 3
this.rowsource = lcSQL


When I exit the .init() I get the error. FoxPro highlights the entire SQL statement. Not just one line.

I think the problem may be one of two things:

1. Don't I need some kind of statment before the first line of my SQL statment that sets the variable.

Ex: lparamaters lcSQL

Then, I can past the SQL statement.

Or,

2. I do not have the piece of code "into cursor Cursor5" in the correct position of the code.

Do you know why I am getting this syntax error, after seeing my code? Am I on the right track as far as troubleshooting with the two suggestions I came up with?

I will try idea #1 when I get back to my development computer tonight. I will let you know how I made out.

Hopefully I can figure this out.

Thanks for your message Cetin. It was very helpful

If, ... strike that............WHEN i get this to work, it will be a great step forward for me. This will be the first time doing such a "proceedure" with a combo box and pview.

Talk to you later

Jason