parse an expression in c

[mathmax]

Hello,

I would like to parse an expression which is a condition of the CA-Clipper language and then translate it into SQL. Do you think that tools like LEX and YACC could help me to solve my problem? Or do you think there is an other better way?

Here is a translation sample:

("Mart" $ Customers->Name .and. Orders->Price >= 120) .or. Oders->Date = ctod("18/06/08")

will be translated to:

where exists (select 0 from Customers as C, Orders as O where C.Id = O.Customers_Id and (C.Name like "%Mart%" and O.Price >= 120) or O.Date = #18/06/08#)

Thank you in advance,

Mathmax

[dargueta]

Whoo, boy, have you got problems ahead of you. You're going to need to make a compiler/translator for this if you can't find anything on the Internet. I don't understand either language, but I can help with creating a basic parser. I did a quick Google search, and you might want to take a look at this:

clipper sql convert - Google Search

[mathmax]

Thank you for your answer.

All the results returned by google are about how to convert .dbf file to SQL tables. This is unfortunately not my issue. I would like to create a Clipper expression parser in order to get a SQL where clause as result.
What do you think about using tools as lex and yacc to do this parser?

regards,

mathmax

[dargueta]

I have no idea. Ask v0id or Jordan, they're very knowledgeable.

[WingedPanther]

What you are looking at creating is basically a compiler, where it has to parse the Clipper language and translate it into the corresponding SQL. You may be able to do it with Regular Expressions, or with LEX & YACC (I'm not familiar with them). One thing that stands out is the fact that there are some definite assumptions that would have to be built into the process (such as the join fields).