| |
| |
|
GDL | Hi,
I must following Entries in a data base insert
INSERT INTO `magic_modules` (`module_id`, `module_description`, `module_type`, `module_enabled`, `module_display_portal`, `module_display_index`, `module_rows`, `module_cols`, `module_path`, `module_template_name`, `module_script_name`) VALUES (, Recent Pictures, Extern, 1, 0, 1, left, 4, magic/, magic_recent_pictures_body, magic_recent_pictures);
INSERT INTO `magic_modules` (`module_id`, `module_description`, `module_type`, `module_enabled`, `module_display_portal`, `module_display_index`, `module_rows`, `module_cols`, `module_path`, `module_template_name`, `module_script_name`) VALUES (, Random Pictures, Extern, 1, 1, 0, center, 5, magic/, magic_random_pictures_body, magic_random_pictures);
INSERT INTO `magic_modules` (`module_id`, `module_description`, `module_type`, `module_enabled`, `module_display_portal`, `module_display_index`, `module_rows`, `module_cols`, `module_path`, `module_template_name`, `module_script_name`) VALUES (, Random Pictures, Extern, 1, 0, 1, left, 5, magic/, magic_random_pictures_body, magic_random_pictures);
i see but only railway-station.
can me Please someone first set so explain, I kapiere what at all made go must ? thanks.
Hello
Georg |
|
| |
| |
| |
|
|
RGH | INSERT INTO : this is the SQL-Bewfehl to that Insert one Satzes into scheduler
magic_modules : this is the name the scheduler in einfachen Hochkommas (on the keyboard Invoice values-#)
(module_id, module_description,...) : the are, each through comma separated, The Feldnamen, The a worth receive should. it would means too imaginable, at Insert the Satzes not any boxes with Inhalten To slip.
VALUES : now follow The values (contents) the before genanten boxes
(, Recent Pictures, Extern, 1, 0, 1, ...) : and the are now through Kommas separated The values for before gelisteten boxes, naturally in same Number and Order. Stringwerte go in simple quotation marks staid, values for numeric fields having no quotation marks.
In XProfan would You whom whole SQL-commands as 1. Parameter of SQLEXEC bring into action, about:
SQLEXEC INSERT INTO magic modules ...., 1
One small Tipp: work simply time whom SQL-course in the XProfan-Help through. there becomes the everything with Examples declared.
Greeting
Roland |
|
| |
| Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4 | 02/10/08 ▲ |
|
| |
|
|
GDL | Hello Roland,
many Thanks for your Help.
on the thoughts with the XProfan SQL basic course be I none come, I always my, the windows- and Inetsprachen two grundverschiedene things are.
Nutze in my Programs only dBase-Files.
Hello
Georg |
|
| |
| |
| |
|
(530)
Deutsch
English
Français
Español
Italia