| |
| |
|
Christof
Neuß | Hi,
Perhaps knows Yes someone here The Solution.
i want over a Selectanweisung simply the first three Split of/ one scheduler inquire. any boxes are me To long and there it it always others tables are, can/I will neither always very The Feldnamen indicate. gives it something in the manner
SELECT Field(1),Field(2),Field(3) From MeineTabelle ???
THANK YOU
Christof |
|
| |
| |
| |
|
|
Detlef
Jagolski | Hi,
what kind of data base have You whom? |
|
| |
| |
| |
|
|
 | Hello Christof,
I faith You seek something like How show index, show fields or. show full fields and could so The Tabellenstruktur invite and so the Statement first produce: [...]  |
|
| |
| |
| |
|
|
Uwe
''Pascal''
Niemeier | Hi people!
this could help:
CompileMarkSeparationwindow 600,600
def %SQL_HANDLE_STMT 3
def %SQL_NTS -3
'--Initialisierung der Datenbank (Typ/Pfad/Name/Schreibweise bitte anpassen!)
'var File$="C:\1Test\"
'var Init$="Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ="+File$+";Extensions=csv"
'var Name$="Test1.csv"
'var File$="C:\1Test\Test1.xls"
'var Init$="Driver={Microsoft Excel-Treiber (*.xls)};DBQ="+File$
'var Name$="[Eingang$]"
var File$="D:\Archive\Einstellungen\Alcatel 701\Nachricht.mdb"
var Init$="Driver={Microsoft Access Driver (*.mdb)};Dbq="+File$'+";Uid=;Pwd=;"
var Name$="Inbox"
db("SQLInit",Init$)
declare Handle&
external("odbc32.dll","SQLAllocHandle",%SQL_HANDLE_STMT,&SQLDBC,addr(Handle&))
var Command$="SELECT TOP 1 * FROM "+Name$'--SQL-Statement zur Auswahl des 1. Datensatzes
external("odbc32.dll","SQLExecDirect",Handle&,Command$,%SQL_NTS)
declare Count&
external("odbc32.dll","SQLNumResultCols",Handle&,addr(Count&))'--Anzahl Felder
declare Text#:dim Text#,255
whileloop 1,Count&
external("odbc32.dll","SQLDescribeCol",Handle&,&loop,Text#,255,0,0,0,0,0)
print &loop,string$(Text#,0)
endwhile
print "Fertig"
external("odbc32.dll","SQLFreeHandle",%SQL_HANDLE_STMT,Handle&)
db("SQLDone")
dispose Text#
waitkey
SeeYou
Pascal |
|
| |
| |
| |
|
|
Christof
Neuß | Hello people,
THANK YOU, so be I moreover come.
Perhaps must I me once more a function write, The simply from the suitable indicated The Feldposition or. whom/The Feldnamen determined and then the value outputs. the wars I there. |
|
| |
| |
| |
|
(886)
Deutsch
English
Français
Español
Italia