XProfan

Gerhard
Praher

Hello Sato,

with DBF-Databases are The Memofelder always in a own File.
this counts sowohl for those from dBase prepares go, as well as for those from Clipper or its Derivaten.
In SQL-Databases are The Memofelder one Feldtyp of/ one scheduler.
that is, that itself one Memo of a Text box, or nummerischen area (as Examples virtual)
even only by the Feldtyp "Memo" discern.
usually having these boxes (How zB. with MS-Access) a Size of 64 KB.
there tappt im dunkeln means regulärer component of/ one scheduler are, go tappt im dunkeln too so addressed How each others area
the scheduler.
Example for a Selektion all boxes of/ one scheduler (The I here time Testtabelle name):
Select * From Testtabelle
take we on the Memo is "MemoFld" and You want only this a area selektieren, then sounds the SQL-commands:
Select MemoFld From Testtabelle

I hope, the helps you a little bit moreover.
Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

08/18/08 ▲

Sato
Pinto

Hello Gerhard

do not have integrally understood, How and where must I the Memo field in Create Table define?
Compile Mark Separation

sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER)"

greeting
Sato

Sato Pinto
WIN XP Home
XPROFAN 11

08/18/08 ▲

Klaus
Müller

Compile Mark Separation

 $sql = "CREATE TABLE `buecher` (
`ID` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titel` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`autor` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`preis` DECIMAL( 3, 2 ) NOT NULL ,
`memo` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;"<

about there.
Greeting Thomas

XProfan X4; Win10 x64
Der Kuchen ist eine lüge!

Gerhard
Praher

Hello Sato,
here a short nomination the Entsprechungen for Datentyp Memo:
with MySQL is it LONGTEXT.
with Firebird is it BLOG.
with SQL-Server is it TEXT.
and with PostgreSQL is it ditto TEXT.

circa simply times the gängigsten To name.
means if I your example hernehme and for a Memo for Notizen erweitere
sees the so from:
Compile Mark Separation

sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER, notizen TEXT)"

or even LONGTEXT or BLOG - depending on which SQL-data base You verwendest.

Greeting Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

Sato
Pinto

Hello

have The mutants attempts, any defective,
Compile Mark Separation

DB& =SQLInit("Driver={Microsoft dBase Driver (*.dbf)};DBQ="+$ProgDir)

IFnot DB& > 0

    @MessageBox("Fehler bei initializierung des driver OBDC.","Fehler OBDC",64)
    Return

endif

@MessageBox("Inicialização do driver OBDC.","OK",64)
waitinput
sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER, notas LONGTEXT)"
sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER, notizen TEXT)"
sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER, notizen LONGTEXT)"
sql$ = "CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMBER, notizen BLOG)"
SQLExec sql$,>0

yet ideas?

greeting
Sato

Sato Pinto
WIN XP Home
XPROFAN 11

Gerhard
Praher

Hello Sato,

means i'm not famous, that dBase a SQL data base is.
means go in and with this drive SQL-Statements not supported.
The only dBase-Version, The me straight falls in, The the can is: dBase IV SQL.
i'd time say: there lying the grundsätzliche Error.

Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

Gerhard
Praher

after You written have, that You everything in SQL make want,
be I do not of it gone out, that it again DBF is.
The usage of ODBC for dBase-Files power these yet long not
to a SQL-data base.

Please überdenke the fundamentally.
The simplest shape of/ one SQL-data base is MS-Access (.MDB).
so can you, like with dBase, The Datenbankdatei on the local
computer in a given Ordner hold.
with all others (SQL-Servern) is the suitable Serversoftware necessary.

wished the only ergänzend note.

Greeting Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

Sato
Pinto

Hello Gehard

thanks for Statement

greeting
Sato

Sato Pinto
WIN XP Home
XPROFAN 11