svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / test / resources / org / gvsig / sqlite / dal / fetchFeatureProviderByReference.sql @ 47579
History | View | Annotate | Download (453 Bytes)
| 1 |
|
|---|---|
| 2 |
-- Count SQL
|
| 3 |
SELECT "test"."ID", |
| 4 |
"test"."Byte", |
| 5 |
"test"."Bool1", |
| 6 |
"test"."Long", |
| 7 |
"test"."Timestamp", |
| 8 |
"test"."Date", |
| 9 |
"test"."Time", |
| 10 |
"test"."Bool2", |
| 11 |
"test"."String", |
| 12 |
"test"."Bool3", |
| 13 |
"test"."Double", |
| 14 |
"test"."Bool4", |
| 15 |
"test"."Float", |
| 16 |
"test"."Bool5", |
| 17 |
"test"."Decimal", |
| 18 |
"test"."Geometry" |
| 19 |
FROM "test" |
| 20 |
WHERE ( ("test"."ID") = (?) ) |
| 21 |
LIMIT 1;
|