| Title: | SQL notes |
| Moderator: | NOVA::SMITHI |
| Created: | Wed Aug 27 1986 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 3895 |
| Total number of notes: | 17726 |
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2646.1 | BEAGLE::GODFRIND | Tue Dec 01 1992 06:26 | 19 | ||
| 2646.2 | We'll fix the docs | ELUDE::GREMBOWICZ | Tue Dec 01 1992 11:43 | 3 | |
| 2646.3 | VARCHAR and C char for SQLMOD | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Tue Dec 01 1992 18:12 | 16 |
| 2646.4 | NOVA::SMITHI | The vegemite kid learns VLDB... :-) | Wed Dec 02 1992 11:39 | 9 | |
| 2646.5 | Answer 1 took me a while to understand | NOVA::MATSUMOTO | Twice half-backed isn't done | Wed Dec 02 1992 11:49 | 18 |
| 2646.6 | The GUS and the SQLRM | ELUDE::GREMBOWICZ | Wed Dec 02 1992 12:29 | 8 | |
| 2646.7 | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 13:57 | 21 | |
| 2646.8 | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 14:00 | 8 | |
| 2646.9 | Is this enough English? | NOVA::MATSUMOTO | Twice half-backed isn't done | Wed Dec 02 1992 14:41 | 78 |
| 2646.10 | Prompting for the doc. folks | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 18:59 | 9 |
| 2646.11 | personal preference follows | ALICAT::BUDILOV | Rdb/VMS acrobat | Wed Dec 02 1992 20:29 | 24 |
| 2646.12 | BEAGLE::GODFRIND | Thu Dec 03 1992 06:13 | 25 | ||
| 2646.13 | ELUDE::GREMBOWICZ | Thu Dec 03 1992 12:54 | 11 | ||
| 2646.14 | Correcting myself | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 13:57 | 26 |
| 2646.15 | You and Jens | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 14:00 | 17 |
| 2646.16 | Not me | BSS::STPALY::MOLLER | Fix it before it breaks | Thu Dec 03 1992 14:45 | 9 |
| 2646.17 | C++ will make things easier? | BROKE::HIGGS | SQL is a camel in disguise | Thu Dec 03 1992 17:00 | 11 |
| 2646.18 | Paranoia? | BROKE::HIGGS | SQL is a camel in disguise | Thu Dec 03 1992 17:03 | 17 |
| 2646.19 | Who me? | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 17:17 | 7 |
| 2646.20 | BEAGLE::GODFRIND | Mon Dec 07 1992 06:54 | 29 | ||
| 2646.21 | New languages, standards, and resources | BROKE::HIGGS | SQL is a camel in disguise | Mon Dec 14 1992 13:34 | 34 |
| 2646.22 | pass char* from C to VARCHAR in SQLMOD | ORAREP::CIM2NI::THORPE | Mon Apr 07 1997 17:13 | 10 | |
What is the trick to pass a char* from C into a SQL module procedure argument that is VARCHAR(x)? A TRACE statement in the procedure shows that the first 2 bytes are being clipped. The procedure argument datatypes are specified using domains. I'm using RDB 6.1 and specifying the SQL92 dialect on OpenVMS Alpha V6.1. Thanks, Bill | |||||
| 2646.23 | NOVA::SMITHI | Don't understate or underestimate Rdb! | Mon Apr 07 1997 17:54 | 8 | |
The *trick* is to pass the data correctly. A VARCHAR is a length-prefixed string. The length is an UNSIGNED WORD, which is why the first two characters appear clipped. Use the $SQL_VARCHAR macro to construct a varchar in C and pass that. Ian | |||||