Solved

SQL with access 97 mdb

Posted on 2004-04-11
5
230 Views
Last Modified: 2010-04-05
Hi,
I use Delphi 5 with a Access 97 mdb and ADO.
In the delphi adoquery1 sql editor i want to do this :

SELECT agv(table1.pourcent)....
FROM ...

But table1.pourcent is a string.
How to convert to int ?

SELECT avg(cint(table1.pourcent)) dont work
also dont work : stringtostr, string_to_str...

Where i can find a document where all the function are detailled ?


Thanks.

0
Comment
Question by:lgc5800
  • 2
5 Comments
 
LVL 27

Assisted Solution

by:kretzschmar
kretzschmar earned 250 total points
ID: 10801402
what is table1? a ttable instance?
0
 

Author Comment

by:lgc5800
ID: 10805307
table1 is a table in the access mdb
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 250 total points
ID: 10806732
what about

SELECT avg(pourcent)....  
FROM table1

??

pourcent is a textfield?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now