General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to make real PostRows with SQL
* Hello to all VFP-SQL Professionals,
* I search an solution to get Post Rows from a Adresstable.
* For example, I have got this Sourcetable:
* TabSource.dBF
*+------------+---------+--------+-------------+------------+
*|Company |FirstName|LastName|Street |City |
*|c(20) |c(10) |c(10) |c(20) | |
*+------------+---------+--------+-------------+------------+
*| |Mickey |Mouse |MainStreet 1 |Disneyland |
*|Wondercars |Batman | |Castle 12 |Gotham City |
*| |Donald |Duck |PoorStreet 13|Ducktown |
*+------------+---------+--------+-------------+------------+
* The SQL Command to get a Targettable with PostRows is easy.
SELECT company as PostRow1, ;
ALLTRIM(firstname+" "+lastname) as PostRow2, ;
street as PostRow3, ;
city as PostRow4 ;
FROM TabSource ;
INTO TABLE TabTarget1
* So I get this TabTarget1.dBF
*+------------+-------------+-------------+------------+
*|PostRow1 |PostRow2 |PostRow3 |PostRow4 |
*+------------+-------------+-------------+------------+
*| |Mickey Mouse |MainStreet 1 |Disneyland |
*|Wondercars |Batman |Castle 12 |Gotham City |
*| |Donald Duck |PoorStreet 13|Ducktown |
*+------------+-------------+-------------+------------+
* But this is not really a Table with PostRows.
*
* How knows the SQL solution, to get this Targettable
* with this real PostRows.
*+------------+-------------+-------------+------------+
*|PostRow1 |PostRow2 |PostRow3 |PostRow4 |
*+------------+-------------+-------------+------------+
*|Mickey Mouse|MainStreet 1 |Disneyland | |
*|Wondercars |Batman |Castle 12 |Gotham City |
*|Donald Duck |PoorStreet 13|Ducktown | |
*+------------+-------------+-------------+------------+
* Many thanks for help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only