Android Question passing field name in function

[Kiran Raotole]

i make function to get value of any field ::

Sub function(sqlite As SQL,book As String,accode As String,return_field) As String
    Return sqlite.ExecQuerySingleResult2("select '" & return_field & "' from GL where FBOOK = ? and FACCODE = ?", _
                                        Array As String(book,accode))
End Sub

this command return field name I want field value

 

[Erel]

It will return the value.

 

[Mahares]

this command return field name I want field value

You need to get rid of the single quotes in return_field in the statement. See correct code below:

Sub function(sqlite As SQL,book As String,accode As String,return_field) As String
    Return sqlite.ExecQuerySingleResult2("select " & return_field & " from GL where FBOOK = ? and FACCODE = ?", _
    Array As String(book,accode))
End Sub

 

[Kiran Raotole]

You need to get rid of the single quotes in return_field in the statement. See correct code below:

Sub function(sqlite As SQL,book As String,accode As String,return_field) As String
    Return sqlite.ExecQuerySingleResult2("select " & return_field & " from GL where FBOOK = ? and FACCODE = ?", _
    Array As String(book,accode))
End Sub

thanks it works.

 

[RichardN]

In the interests of keeping code as readable as possible I always name my own variables and sqlite fields with descriptive mixed-case names and construct SQL Queries using capitals for Sqlite reserved words. It is only a small detail but when queries (or their concantation) become complicated it makes it far easier to read.

Like this:

Return Sqlite.ExecQuerySingleResult2("SELECT " & ReturnField & " FROM Gl WHERE Fbook = ? AND FacCode = ?", Array As String(Book,AcCode))

For what it's worth.......

 

[Diceman]

i make function to get value of any field ::

Sub function(sqlite As SQL,book As String,accode As String,return_field) As String
    Return sqlite.ExecQuerySingleResult2("select '" & return_field & "' from GL where FBOOK = ? and FACCODE = ?", _
                                        Array As String(book,accode))
End Sub

this command return field name I want field value

Aren't you missing "as string" in the argument list for "return_field"?
Sub function(sqlite As SQL,book As String,accode As String,return_field as String) As String

I assume the value you are returning is a simple value like a string or numeric? And not a bitmap?

 

[Mahares]

Aren't you missing "as string" in the argument list for "return_field"?

It defaults to String if declaration is missing (warning #5), but it will work. It is the column name, so most likely a string.