| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 2646.1 | | BEAGLE::GODFRIND | Faut que je pense � ma carri�re | Tue Dec 01 1992 03:26 | 19 |
| 2646.2 | We'll fix the docs | ELUDE::GREMBOWICZ | | Tue Dec 01 1992 08:43 | 3 |
| 2646.3 | VARCHAR and C char for SQLMOD | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Tue Dec 01 1992 15:12 | 16 |
| 2646.4 | | NOVA::SMITHI | The vegemite kid learns VLDB... :-) | Wed Dec 02 1992 08:39 | 9 |
| 2646.5 | Answer 1 took me a while to understand | NOVA::MATSUMOTO | Twice half-backed isn't done | Wed Dec 02 1992 08:49 | 18 |
| 2646.6 | The GUS and the SQLRM | ELUDE::GREMBOWICZ | | Wed Dec 02 1992 09:29 | 8 |
| 2646.7 | | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 10:57 | 21 |
| 2646.8 | | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 11:00 | 8 |
| 2646.9 | Is this enough English? | NOVA::MATSUMOTO | Twice half-backed isn't done | Wed Dec 02 1992 11:41 | 78 |
| 2646.10 | Prompting for the doc. folks | SELKRK::MARSAN | Rick Marsan (Doctor Flash) | Wed Dec 02 1992 15:59 | 9 |
| 2646.11 | personal preference follows | ALICAT::BUDILOV | Rdb/VMS acrobat | Wed Dec 02 1992 17:29 | 24 |
| 2646.12 | | BEAGLE::GODFRIND | Faut que je pense � ma carri�re | Thu Dec 03 1992 03:13 | 25 |
| 2646.13 | | ELUDE::GREMBOWICZ | | Thu Dec 03 1992 09:54 | 11 |
| 2646.14 | Correcting myself | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 10:57 | 26 |
| 2646.15 | You and Jens | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 11:00 | 17 |
| 2646.16 | Not me | BSS::STPALY::MOLLER | Fix it before it breaks | Thu Dec 03 1992 11:45 | 9 |
| 2646.17 | C++ will make things easier? | BROKE::HIGGS | SQL is a camel in disguise | Thu Dec 03 1992 14:00 | 11 |
| 2646.18 | Paranoia? | BROKE::HIGGS | SQL is a camel in disguise | Thu Dec 03 1992 14:03 | 17 |
| 2646.19 | Who me? | NOVA::MATSUMOTO | Twice half-backed isn't done | Thu Dec 03 1992 14:17 | 7 |
| 2646.20 | | BEAGLE::GODFRIND | Faut que je pense � ma carri�re | Mon Dec 07 1992 03:54 | 29 |
| 2646.21 | New languages, standards, and resources | BROKE::HIGGS | SQL is a camel in disguise | Mon Dec 14 1992 10:34 | 34 |
| 2646.22 | pass char* from C to VARCHAR in SQLMOD | ORAREP::CIM2NI::THORPE | | Mon Apr 07 1997 14: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 14: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
|