English
Forum

Done: with SQL count

 

Sato
Pinto
Hello

want with SQL, date to charge, still probably because I the area for the date
into Dbf File as C 10 definiert have, is it now difficult or not possibly so To calculate.
Perhaps has someone of you a Solution moreover.

means into Dbf File have one area the "ultvisit" means and there see The Entries as Text
z.b so from 20091101
20090319
so, now give I in a Edit The days The from the actually date back accounts
go should, z.b give 30 days one and get 20091002 whom I in one variable Text$
save.

now the trouble
LVSQL "select cdummy, cnome, crua, clocal, ccp, ctecnico, ultvisita FROM clientes where ultvisita <= :Text$",liste&

and the functions it lögischeweise not correctly., dar ultvisit not as date viewing becomes
can not correctly. calculate. what I so wants, is any Datensätze in a list darzustellen
where ultvisit small or same the Content of Text$. has someone a idea The differently is as the
area ultvisit as date To define?

greeting
Sato
 
Sato Pinto
WIN XP Home
XPROFAN 11
11/01/09  
 




Sato
Pinto
Hello

has itself Done, functions still. I had only a incorrect übelegung

thanks

greeting
Sato
 
Sato Pinto
WIN XP Home
XPROFAN 11
11/01/09  
 




Rolf
Koch

thanks


Please gladly happen *lol* ^^
 
11/01/09  
 



would have been it still same demand.
 
11/01/09  
 



Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

5.424 Views

Untitledvor 0 min.
Thomas Zielinski11/02/21
holmol9309/30/13
Andre Rohland01/21/12
Peter Max Müller01/16/12

Themeninformationen

this Topic has 3 subscriber:

Sato Pinto (2x)
iF (1x)
Rolf Koch (1x)


Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie