GetColumnName

[sultan87]

good evening
I wish to know the name of the fields of my table

Curseur = SQL.ExecQuery("SELECT * FROM Relevés")
NumberOfColumns = curseur.ColumnCount
Dim ColumnName(NumberOfColumns) As String ' names of the columns
For i = 0 To curseur.ColumnCount - 1
ColumnName(i) =curseur.GetColumnName(i)
Next i
When I compile it leaves me an error

Compiling code. 0.78
Generating R file. 0.01
Compiling generated Java code. Error
B4A line: 71
ColumnName(i) =curseur.GetColumnName(i)
javac 1.6.0_27
src\BA4\Gestion_Energies\frmhistoreleves.java:322: not a statement
_i;
^
1 error

best regards

 

[Erel]

You should change:

Next i

To:

Next

 

[sultan87]

good evening
sometimes thank you it is necessary to have the sight d' a third nobody
I post another message concerning "synchronization" could you give me your point of view
Best regards