I have two problems with DBF

[tarafrench]

Hi everyone

Here are my problems.

 

1) In the table there is a field "Date". How can I make a request, if it is a reserved word in SQL? Rename field is impossible.

 

I make a request to the DataBase Desktop: select Date from "Sales.DBF", displays the message: Invalid use of keyword

 

2) making a request:

 

select ListNo, sum (Amount) from "Sales.DBF"

group by ListNo

 

It displays a message "Operation not applicable". Where is the mistake?

[Benergy]

Hi everyone

Here are my problems.

Are you using FoxPro or SQL or what on the DBF?

Hope these help:

 

1.) 

SELECT * FROM Sales FOR [DATE] = {^2016-01-25} 'Or whatever your date is

2.)

SELECT [ListNo], (SELECT SUM(Amount) FROM [Sales.dbf]) AmountFROM [Sales.dbf]GROUP BY [ListNo]

[jaedenpreston]

 

Are you using FoxPro or SQL or what on the DBF?

Hope these help:

 

1.) 

SELECT * FROM Sales FOR [DATE] = {^2016-01-25} 'Or whatever your date is

2.)

SELECT [ListNo], (SELECT SUM(Amount) FROM [Sales.dbf]) AmountFROM [Sales.dbf]GROUP BY [ListNo]

Nice ansver. I agree. And if it doesn`t help I suggest you to stop waisting your time and use this program DBF Repair Kit. You can find it here http://www.dbf.repair/