TIP OF THE DAY!!! : SQL request and speed ? III

[Ruslan Zasukhin]

On 10/30/05 8:50 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> Great. I thought it doesn't but it seems that I use it always for
> insert and update.
> 
> 
>> 
>> Point is that you use
>> 
>>     VCursor.AddRecord()  -- this is Sql Way but with some API
>> 
>> Or
>> 
>>    Vtable.AddRecord() -- this is pure API way.
> 
> 
> is following API-Way?
> 
>    meineDatenbank.TBuchungen.setblank
>     Call parsedate(EditField1.text.trim,CheckDate)
>     meineDatenbank.TBuchungen.BDatum.Set(CheckDate.year,
> CheckDate.month, CheckDate.day)
> 
>    meineDatenbank.TBuchungen.Kategorie_ID.value=AktuelleKategorie
> 
>    if EditField4(0).text.cdbl<>0 then
>      //Ausgabe
>      meineDatenbank.TBuchungen.Betrag.value=RoundTextNumber(EditField4
> (0).text)
>      meineDatenbank.TBuchungen.Herk_Konto.value=AktuellesKonto
>      meineDatenbank.TBuchungen.Ziel_Konto.value=AktuellesGegenKonto
>    else
>      //Einnahme
>      meineDatenbank.TBuchungen.Betrag.value=RoundTextNumber(EditField4
> (1).text)
>      meineDatenbank.TBuchungen.Herk_Konto.value=AktuellesGegenKonto
>      meineDatenbank.TBuchungen.Ziel_Konto.value=AktuellesKonto
>    end if
>    if NOT CheckLeer(EditField5.text) then
> meineDatenbank.TBuchungen.Kommentar.Value=EditField5.text.trim
>    meineDatenbank.TBuchungen.Blocked.value=false
>    NewRecID=meineDatenbank.TBuchungen.addRecord
> 
>    meineDatenbank.TBuchungen.flush

YES this is API way.

    you use REALBasic methods. Not SQL commands.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]