APIs - .NET

[william humphrey]

There are many ways to do that. Like you I never use the pointer, or
whatever its called, which loads all the records in a SQL query and then
goes through them. I always pull out the specific record I want with all
the related tables and parse that out in the fields on my Livecode card.

I use variations of:

 *put* VDatabase_SqlSelect( gDatabase, tSQL ) into CursorRef

   *put* VCursor_RecordCount(CursorRef) into recNum

   *if* recNum > 0 *then*

      *put* VCursor_GetRecord( CursorRef,, tab ) INTO tTextHolder

   *else*

    CallMyError

   *end* *if*

I hope this helps. Honestly I do lots and lots of stuff just with that one
method. I never could figure out the many other methods that are possible.


On Wed, Oct 10, 2012 at 7:13 AM, DMW <consult at excelkb.com> wrote:

> **
>
> Hi all,
>
> After working a lot with SQL I have decided to explore and learn more
> about Valentinas APIs.
>
> The samples at the Wiki is quite simplified and do not provide enough
> guidelines enabling me to understand some aspects here.
>
> Q1: If I want to show a specific record’s data (not the first, not the
> last, not the next, not the previously).
> I need to make some kind of look up first – how do I do that?
>
> Second,  I want to grab the data for that record and show it in the Form -How do I do that?
>
> That’s all for now!
>
> TIA,
> Dennis
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20121010/dda62915/attachment.html>