How to use NULL values with SQLRDD - xharbour

HI ajbodoc :

TRY :

NOT_NULL_MAKE()

**********************
FUNCTION NOT_NULL_MAKE()

LOCAL aStruct,I

aStruct := dbStruct()

FOR I:=1 TO LEN(aStruct)
IF aStruct[I][2]#"D"
SR_ADDRuleNotNull( aStruct[I][1] )
ENDIF
NEXT I

RETURN NIL

Hello Antonio,

> Friends, I have foreing key with 1 o more fields, this fk will be
> NULLs values eventually in the bussiness rule. Bat how to store NULL
> values with xbase commands'.

What version of SQLRDD are you using?

--
Sincerely,

Patrick Mast,
www.xHarbour.com

On 2 nov, 05:36, Patrick Mast <Patrick.RemoveThis.M...@xHarbour.com>
wrote:
> Hello Antonio,
>
> > Friends, I have foreing key with 1 o more fields, this fk will be
> > NULLs values eventually in the bussiness rule. Bat how to store NULL
> > values with xbase commands'.
>
> What version of SQLRDD are you using?
>
> --
> Sincerely,
>
> Patrick Mast,www.xHarbour.com

SQLRDD 7.1 (Demo) for Borland C 5.5 a xHarbour 0.99.71 and PostGreSql
8.2

Thank

On 2 nov, 00:42, "kokoo...@gmail.com" <kokoo...@gmail.com> wrote:
> HI ajbodoc :
>
> TRY :
>
> NOT_NULL_MAKE()
>
> **********************
> FUNCTION NOT_NULL_MAKE()
>
> LOCAL aStruct,I
>
>    aStruct := dbStruct()
>
>    FOR I:=1 TO LEN(aStruct)
>       IF aStruct[I][2]#"D"
>          SR_ADDRuleNotNull( aStruct[I][1] )
>       ENDIF
>    NEXT I
>
> RETURN NIL

Thank;
but i need use null values (my problem is use it values). Your
function is for create notnull constraint,(is good bat not for this
problem).

In SQL "null value" is "a field which has been never initialized with a
value".

Ella

"ajbodoc" <ajbodoc@gmail.com> wrote in message
news:91211ab2-1f13-49d9-9e9e-8eb80da9a917@r15g2000prh.googlegroups.com...
On 2 nov, 00:42, "kokoo...@gmail.com" <kokoo...@gmail.com> wrote:
> HI ajbodoc :
>
> TRY :
>
> NOT_NULL_MAKE()
>
> **********************
> FUNCTION NOT_NULL_MAKE()
>
> LOCAL aStruct,I
>
> aStruct := dbStruct()
>
> FOR I:=1 TO LEN(aStruct)
> IF aStruct[I][2]#"D"
> SR_ADDRuleNotNull( aStruct[I][1] )
> ENDIF
> NEXT I
>
> RETURN NIL

Thank;
but i need use null values (my problem is use it values). Your
function is for create notnull constraint,(is good bat not for this
problem).

Thank Ella.

I know what NULL values is default status of database fields. But when
whit DbAppend() function is use for add new row in table of database
all fields receive any value (NOT NULL).



On 3 nov, 11:52, "Ella Stern" <ella.st...@xharbour.com> wrote:
> In SQL "null value" is "a field which has been never initialized with a
> value".
>
> Ella
>
> "ajbodoc" <ajbo...@gmail.com> wrote in message
>
> news:91211ab2-1f13-49d9-9e9e-8eb80da9a917@r15g2000prh.googlegroups.com...
> On 2 nov, 00:42, "kokoo...@gmail.com" <kokoo...@gmail.com> wrote:
>
>
>
>
>
> > HI ajbodoc :
>
> > TRY :
>
> > NOT_NULL_MAKE()
>
> > **********************
> > FUNCTION NOT_NULL_MAKE()
>
> > LOCAL aStruct,I
>
> > aStruct := dbStruct()
>
> > FOR I:=1 TO LEN(aStruct)
> > IF aStruct[I][2]#"D"
> > SR_ADDRuleNotNull( aStruct[I][1] )
> > ENDIF
> > NEXT I
>
> > RETURN NIL
>
> Thank;
> but i need use null values (my problem is use it values). Your
> function is for create notnull constraint,(is good bat not for this
> problem).- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -

In my understanding xBase doesn't have the concept of NULL fields.
I'd try to write a test program, which uses exclusively oSql:Exec(...), so
it contains Insert, Update, Delete, Select.

Ella

"ajbodoc" <ajbodoc@gmail.com> wrote in message
news:0d773e92-86c1-4214-8281-1ecc977dfa05@a29g2000pra.googlegroups.com...
> Thank Ella.
>
> I know what NULL values is default status of database fields. But when
> whit DbAppend() function is use for add new row in table of database
> all fields receive any value (NOT NULL).
>

This is posible without problem, but is a hard work for any
applications that have many tables.
SQLRDD is xBase RDD but it add more extension that suply xBase
concepts in interaction with relational data bases; NULL (equivalent a
NIL concept) is more util.

Thank for your attention


On 4 nov, 08:40, "Ella Stern" <ella.st...@xharbour.com> wrote:
> In my understanding xBase doesn't have the concept of NULL fields.
> I'd try to write a test program, which uses exclusively oSql:Exec(...), so
> it contains Insert, Update, Delete, Select.
>
> Ella
>
> "ajbodoc" <ajbo...@gmail.com> wrote in message
>
> news:0d773e92-86c1-4214-8281-1ecc977dfa05@a29g2000pra.googlegroups.com...
>
>
>
> > Thank Ella.
>
> > I know what NULL values is default status of database fields. But when
> > whit DbAppend() function is use for add new row in table of database
> > all fields receive any value (NOT NULL).- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -