SQL Tutorial

[Erel]

Thanks.

How are you loading the data to SQL?

 

[Domingo]

Whit this aplication modified from another of this forum

 

[Erel]

Can you post a small CSV file?

 

[Domingo]

In this example there are "ñ", ª,
The SQLite Database Browser aplication do a good translation,works fine. From the same csv file lalista.csv (doing File - Import - Table from csv file).
Thanks for all

 

[Erel]

The CSV file was not encoded with Unicode.
Try the attached file, it should work.

With Notepad you can choose Save As and then there is an option at the bottom of the dialog to change to Unicode.

 

[Domingo]

Yes, it work fine. Thanks.
This csv file is the result of the other programm that I use and maked from Visual Basic of Microsoft. Couriosly is posible to translate to sqlite ussing the Sqlite Database Browser.
Another question. I want use the random files access that I used in ppc, but in android. What is the similar to this in basic4android?
FileOpen (c1, "text.dat",cRandom)
s = FileGet (c1, 5,10) 's will be a string with 10 characters starting from the sixth character in the file.
FileClose(c1)

Thanks for your attentions

 

[Erel]

Please start a new question in the Basic4android questions subforum: Basic4android Updates and Questions - Basic4ppc / Basic4android - Android programming

 

[juncus]

Step 1 - Adding SQL support to your Basic4ppc application

The SQL tutorial is available here: Basic4ppc SQL library reference

Please feel free to post questions or comments in this thread.

Well at step 1 it all falls apart there is no 'Components' item on the tools menu. There is no apparent way to add a .dll. There is no SQLDesktop in the libraries. if one assumes equivalence.

I'm not very happy about this I wanted to get on with writing a program but if the documentation is so poor there is very little chance.:BangHead:

 

[mjcoon]

... there is no 'Components' item on the tools menu. There is no apparent way to add a .dll.

Just a check: are you running Basic for Android but looking at a tutorial for Basic for PPC?

I don't think it would be right to assume or claim "equivalence" between these two...

Mike.

 

[Erel]

For Basic4android see this: Basic4android - Android programming with Gui designer

 

[mjcoon]

I just went to the SQL tutorial at ãó çãù 1 and find the browser heading looks strange because the source contains

<title>דף חדש 1</title>

(I don't even know what that language is!)

Mike.

 

[agraham]

Hebrew for "New page" according to Google Translate.

 

[mjcoon]

Hebrew for "New page" according to Google Translate.

To be honest I was sure it would be Hebrew, though I hadn't thought of using Google Translate. We've come a long way since ASCII-only, haven't we!

Mike.

 

[jaycac]

Error adding sql library

Hi,

I'm new to B4A. I need your help guys. I encountered an error when adding sql library.

 

[Erel]

You are posting in the wrong forum.