04-06-2006
$include "getsum.h"....
actually this getsum.h contains ESQL(Embeded SQL) Header structures......
my code uses pro*c for DB connection.
My OS is SUNsolaris.......
And I don't know whether I am using any precompiler, it's not a standalone program, so i have certain procedure for compilation.... but I thought it may have some precompiler, b'coz I am using pro*c ... I don't have a much idea about pro*c ... this is my 1st time I am working with pro*c....
plz clarify.....
Sarwan
Last edited by sarwan; 04-06-2006 at 08:12 AM..
Reason: For better clarity
10 More Discussions You Might Find Interesting
1. Programming
Hi,
I am new to the unix networking.
I have written one client and server for UDP sockets..
I got the following errors while conpilation
I have include all include files.
Could some one help ...is there any other file to be included.....?
will the include files change on different unix... (3 Replies)
Discussion started by: reddyb
3 Replies
2. UNIX for Dummies Questions & Answers
I have a file that contains some variables that I may want to share throughout multiple scripts.
I think there's an #include command in UNIX.
How do I use it (in korn)? (1 Reply)
Discussion started by: yongho
1 Replies
3. UNIX for Advanced & Expert Users
I want to include all the subnet files under /etc/dhcpd/ to /etc/dhcpd.conf
so here is my content of dhcpd.conf
...
include "/etc/dhcpd/*";
however, the check-syntax reports syntax error, as they do not recognize the wildcard *, and display that " file /etc/dhcpd/* could not be found.
... (1 Reply)
Discussion started by: fredao
1 Replies
4. Shell Programming and Scripting
Hi,
I have an easy question...
My ksh script has a section with non ksh script in it - let's pretent it is VBA code. I need to include this vba script in my ksh script into so that my VBA script can be reused elsewhere by other ksh script by "$include" into other ksh scripts. What is the syntax... (3 Replies)
Discussion started by: ihot
3 Replies
5. Programming
Hi there,
I'm working on a c++ project and I need to use some libraries which are part of a framework. I installed it on my home directory, and alle the .hh are located in subdirs of my home.
I'd like to include the files I need just as if they where std c header, that is:
#include... (2 Replies)
Discussion started by: clalfa
2 Replies
6. Shell Programming and Scripting
Hello,
I have a script and a second file that contains all parameters needed for the script.
How can I include this file in the script ?
I tried source but I have a "no such file or directory" error.
:) (1 Reply)
Discussion started by: pppswing
1 Replies
7. Shell Programming and Scripting
Hi Experts,
Greetings! ,
I have a list of lvs that is having 3 column separated by / .
Want to add "r" after the 3rd / :
/dev/vgdbnhpu/u01
/dev/vgdbnhpu/u02
/dev/vgdbnhpu/u03
/dev/vgdbnhpu/u04
/dev/vgdbnhpu/u05
/dev/vgdbnhpu/u06
/dev/vgdbnhpu/u07
/dev/vgdbnhpu/u08... (4 Replies)
Discussion started by: rveri
4 Replies
8. Programming
i have three files
a.h t.c and p.c
a.h has 3 functions only and does not include anything
p.c has one function i made called go
t.c has a main function and calls the go function, it includes a.h only
i run the program using
gcc -Wall -g -o t p.c t.c
but i get a warning, implicet... (2 Replies)
Discussion started by: omega666
2 Replies
9. Red Hat
RHEL 5.4
I'm trying to use %include statements in my kickstarts, and am running into some problems.
In %pre, I can %include /mnt/source/isolinux/setup-questions and that works just fine. One of the things it does is echo out several variables to /tmp/vars In %post --nochroot, I copy... (2 Replies)
Discussion started by: jnojr
2 Replies
10. Programming
I have an implementation file tomog.cpp that implements a class called Tomog where I need to include its header file which resides in another place.
How can I best specify the include file? I would not like to do
#include "../../tomso/tomography/tomog.hpp"
I wish to do instead
... (3 Replies)
Discussion started by: kristinu
3 Replies
LEARN ABOUT PHP
sql-acceptable-by-4d
SQL-ACCEPTABLE-BY-4D(3) 1 SQL-ACCEPTABLE-BY-4D(3)
SQL acceptable by 4D - PDO and SQL 4D
4D implements strictly the ANSI 89 standard, and have it enforced. It is highly recommended to read the 4D SQL documentation to learn
about the available commands. The URL of the manual is : http://doc.4d.com/. Below is a list of 4D SQL characteristics: it is not exhaus-
tive, but may serve as an introduction.
Characteristics of 4D SQL
+-------------------------------------+--------------------------------------+---+
| Characteristics | | |
| | | |
| | Alternative | |
| | | |
| | Note | |
| | | |
+-------------------------------------+--------------------------------------+---+
| INTEGER | | |
| | | |
| | Modify the SQL to use INT. | |
| | | |
| | INT is the supported integer type in | |
| | 4Dv12.0. | |
| | | |
| CHAR | | |
| | | |
| | Use VARCHAR instead. | |
| | | |
| | Unsupported in 4Dv12.0 | |
| | | |
| UNION | | |
| | | |
| | Unsupported. Make separate queries. | |
| | | |
| | Unsupported in 4Dv12.0 | |
| | | |
| SELECT 1 + 1; | | |
| | | |
| | SELECT 1 + 1 FROM _USER_SCHEMAS; | |
| | | |
| | FROM is required | |
| | | |
| FLOAT | | |
| | | |
| | Cast the FLOAT value into a FLOAT or | |
| | STRING, with an SQL 4D function | |
| | (CAST, ROUND, TRUNC or TRUNCATE) | |
| | | |
| | Unsupported in current versions of | |
| | the PDO_4D driver | |
| | | |
| Strong typing | | |
| | | |
| | Take care your SQL query, or your | |
| | PHP code provides data with the | |
| | expected type | |
| | | |
| | One must provide the right type | |
| | that 4D expect. One can't insert '1' | |
| | (as a string) in an INTEGER column. | |
| | | |
|PDO.execute(row)(3) : only works if | | |
|all the table's column are of type | | |
|TEXT or VARCHAR | | |
| | | |
| | Use the prepared statements, and use | |
| | the right types. | |
| | | |
| | The PDO extension cast all values | |
| | through execute() as string, and | |
| | expect the SQL database to parse the | |
| | values. | |
| | | |
| SELECT NULL FROM TABLE | | |
| | | |
| | Do not use NULL constants. Extract | |
| | them from the table | |
| | | |
| | It is not allowed to use the NULL | |
| | constant in the select list | |
| | | |
| SELECT * FROM TABLE WHERE 1 | | |
| | | |
| | Use WHERE 1 = 1 | |
| | | |
| | A constant can't be used in a WHERE | |
| | clause | |
| | | |
| SHOW TABLES | | |
| | | |
| | Use system tables | |
| | | |
| | The list of tables, schemas, index, | |
| | etc. are in these system tables : | |
| | _USER_TABLES, _USER_COLUMNS, | |
| | _USER_INDEXES, _USER_CONSTRAINTS, | |
| | _USER_IND_COLUMNS, _USER_CONS_COL- | |
| | UMNS, and _USER_SCHEMAS. | |
| | | |
| SQL structure delimiter | | |
| | | |
| | Use the following function to pro- | |
| | tect SQL elements: function | |
| | sqlEscapeElement(elem) { return '[' | |
| | . str_replace(']',']]', $elem) . | |
| | ']'; } | |
| | | |
| | To escape SQL elements names | |
| | (tables, fields, users, groups, | |
| | schema, primary key, etc.), the | |
| | whole identifier must be between | |
| | square brackets, and the closing | |
| | brackets ']' must be doubled. | |
| | | |
+-------------------------------------+--------------------------------------+---+
PHP Documentation Group SQL-ACCEPTABLE-BY-4D(3)