Please members i have two tables sentmessages and recivedmessages but iam failing to view the list of of information returned from diferent especially the one for sentmessages when i click on sent for the first time it doesnot show any record but on the second time it shows the table with more columns please how can i implement this modify my code from this attachment to help you get what i wanted please help me iam failing out on this yet i wanted to implement this using B4xtable please help
-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Android Question using b4xtable to view send and recieved sms
- Thread starter Makumbi
- Start date
- Similar Threads Similar Threads
See Erels answer here! https://www.b4x.com/android/forum/threads/b4xtable-shows-duplicated-columns.104761/#post-656339
You REALLY should follow the advice!!!!! You are still adding colums multiple times.
Don´t expect me to do anything here to help.
You REALLY should follow the advice!!!!! You are still adding colums multiple times.
Don´t expect me to do anything here to help.
Upvote
0
Please DonManfred show me that very code from my attachment because yesterday i tried Erels answer here! https://www.b4x.com/android/forum/threads/b4xtable-shows-duplicated-columns.104761/#post-656339 but the problem still can not be solved please highlight for me that very code that is creating problems . i have spent sleepless nights on this thing please help
Upvote
0
I have tried to get your sample project working with no luck. (no data displayed in Table full stop)
There is Data being received from http jobs but it is not getting placed /stored in the database tables for final display in your Table.
It would appear all this current problem / threads is due to the fact you wish your 1st Column Title to have a different Title depending on the data displayed.
Just load your Table Columns Once only in Activity_Create ... (Not in any other Sub) and give the 1st column a title of "Date" (Problem Solved for the time being)
I thought you should be able to change the column title when necessary with ...
but it is not working and I will follow it up ...
If you need any further help (regarding records not displaying)you really need to upload the most Basic, Stripped Down sample ...
That has just enough code to achieve what you are trying to do , but failing. (by doing that you will most likely solve the problem yourself.)
ps: I have a test projects where each new element or task is tested and researched .. only when it is running 100% (well 95%) , do i incorporate it into the main project.
Get the b4xTable example back out and load it with a small amount of dummy data ... in a way that mirrors your project. Keep it very simple.
When you have got it working the way you wish you will have template code for you project.
ps2: you do not need to call DateTime.Format before each DateTime interaction / display code block.
Once you have set the format it is as is until you reset / change the format again.
There is Data being received from http jobs but it is not getting placed /stored in the database tables for final display in your Table.
It would appear all this current problem / threads is due to the fact you wish your 1st Column Title to have a different Title depending on the data displayed.
Just load your Table Columns Once only in Activity_Create ... (Not in any other Sub) and give the 1st column a title of "Date" (Problem Solved for the time being)
I thought you should be able to change the column title when necessary with ...
B4X:
Private DateColumn As B4XTableColumn 'Global
Sub Activity_Create(FirstTime As Boolean)
DateColumn = B4XTable1.AddColumn("Date", B4XTable1.COLUMN_TYPE_TEXT)
'then somewhere later ....
DateColumn.Title = "Date Recieved"but it is not working and I will follow it up ...
If you need any further help (regarding records not displaying)you really need to upload the most Basic, Stripped Down sample ...
That has just enough code to achieve what you are trying to do , but failing. (by doing that you will most likely solve the problem yourself.
)ps: I have a test projects where each new element or task is tested and researched .. only when it is running 100% (well 95%) , do i incorporate it into the main project.
Get the b4xTable example back out and load it with a small amount of dummy data ... in a way that mirrors your project. Keep it very simple.
When you have got it working the way you wish you will have template code for you project.
ps2: you do not need to call DateTime.Format before each DateTime interaction / display code block.
Once you have set the format it is as is until you reset / change the format again.
Upvote
0
As a follow up ... (to solve one of your problems )
1. Declare a B4XTableColumn object in Globals ..
2. Set your Table columns in Activity_Create (or somewhere else , But only Once)
3. Edit / change the column title when neccessary
B4X:
Private DateColumn As B4XTableColumn 'Global declaration.
Sub Activity_Create(FirstTime As Boolean)
DateColumn = B4XTable1.AddColumn("Date", B4XTable1.COLUMN_TYPE_TEXT)
B4XTable1.AddColumn("Sms", B4XTable1.COLUMN_TYPE_TEXT)
B4XTable1.AddColumn("ID", B4XTable1.COLUMN_TYPE_TEXT)
'.....................
Sub ShowTable 'Again .. You should rename this to something like ... DisplaySentSMS
'...........................
B4XTable1.SetData(data)
Dim pnl As B4XView = DateColumn.CellsLayouts.Get(0) 'header panel
pnl.GetView(0).Text = "Date Sent"
Sub ShowTable2 'how about .. DisplayReceivedSMS
'...........................
B4XTable1.SetData(data)
Dim pnl As B4XView = DateColumn.CellsLayouts.Get(0) 'header panel
pnl.GetView(0).Text = "Date Received"Best of luck ...
Upvote
0
thanks for the support where do i place this code
B4X:
Dim rs As ResultSet = Starter.SQL1.ExecQuery("SELECT DISTINCT Datesent,Sms as SentMessage,ID FROM Sentmessages")
Do While rs.NextRow
Dim row(4) As Object
row(0) = rs.Getstring("Datesent")
row(1) = rs.GetString("SentMessage")
'Log(row(0))
'Log(row(1))
'Log(row(2))
'& " " & rs.GetString("LastName")
row(2) = rs.GetString("ID")
'Some of the fields are Null. We need to convert them to empty strings:
If row(2) = Null Then row(2) = ""
row(1) = rs.GetString("SentMessage")
data.Add(row)
Loop
rs.Close
Upvote
0
I Have tried it this way but the code gives me this error
B4X:
Dim pnl As B4XView = DateColumn.CellsLayouts.Get(0) 'header panel
pnl.GetView(0).Text = "Date Sent"
data.Initialize
Dim rs As ResultSet = Starter.SQL1.ExecQuery("SELECT DISTINCT Datesent,Sms as SentMessage,ID FROM Sentmessages")
Do While rs.NextRow
Dim row(4) As Object
row(0) = rs.Getstring("Datesent")
row(1) = rs.GetString("SentMessage")
'Log(row(0))
'Log(row(1))
'Log(row(2))
'& " " & rs.GetString("LastName")
row(2) = rs.GetString("ID")
'Some of the fields are Null. We need to convert them to empty strings:
If row(2) = Null Then row(2) = ""
row(1) = rs.GetString("SentMessage")
data.Add(row)
Loop
rs.Close
B4XTable1.SetData(data)here is the error i get
B4X:
Error occurred on line: 601 (B4XTable)
android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE data )
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)
at anywheresoftware.b4a.sql.SQL.ExecNonQuery(SQL.java:74)
at b4a.example.b4xtable._createtable(b4xtable.java:1979)
at b4a.example.b4xtable$ResumableSub_SetData.resume(b4xtable.java:406)
at b4a.example.b4xtable._setdata(b4xtable.java:345)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:180)
at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:262)
at b4a.example.main._showtable(main.java:1394)
at b4a.example.main._btnedit_click(main.java:1383)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:180)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
at android.view.View.performClick(View.java:5610)
at android.view.View$PerformClick.run(View.java:22265)
at android.os.Handler.handleCallback(Handler.java:751)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:154)
at android.app.ActivityThread.main(ActivityThread.java:6077)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:866)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:756)
Upvote
0
The code runs but when it reaches at
B4X:
B4XTable1.SetData(data)
B4X:
Error occurred on line: 601 (B4XTable)
android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE data )
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)
at anywheresoftware.b4a.sql.SQL.ExecNonQuery(SQL.java:74)
at b4a.example.b4xtable._createtable(b4xtable.java:1979)
at b4a.example.b4xtable$ResumableSub_SetData.resume(b4xtable.java:406)
at b4a.example.b4xtable._setdata(b4xtable.java:345)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:180)
at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:262)
at b4a.example.main._showtable(main.java:1394)
at b4a.example.main._btnedit_click(main.java:1383)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:180)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
at android.view.View.performClick(View.java:5610)
at android.view.View$PerformClick.run(View.java:22265)
at android.os.Handler.handleCallback(Handler.java:751)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:154)
at android.app.ActivityThread.main(ActivityThread.java:6077)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:866)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:756)
Upvote
0
B4X:
Sub Activity_Create(FirstTime As Boolean)
If FirstTime Then
smiley = LoadBitmapResize(File.DirAssets, "smiley.png", 24dip, 24dip, False)
End If
'Do not forget to load the layout file created with the visual designer. For example:
'If IsConnectedToInternet=True Then
replysms
'HighPriority_Notification
Activity.LoadLayout("simplechat")
Activity.Title="Chat"
DateColumn = B4XTable1.AddColumn("Date", B4XTable1.COLUMN_TYPE_TEXT)
B4XTable1.AddColumn("Sms", B4XTable1.COLUMN_TYPE_TEXT)
B4XTable1.AddColumn("ID", B4XTable1.COLUMN_TYPE_TEXT)
B4X:
Sub ShowTable
Dim pnl As B4XView = DateColumn.CellsLayouts.Get(0) 'header panel
pnl.GetView(0).Text = "Date Sent"
End Sub
Sub ShowTable2
Dim pnl As B4XView = DateColumn.CellsLayouts.Get(0) 'header panel
pnl.GetView(0).Text = "Date Received"
'B4XTable1.SetData(data)
End SubNow which code can i use to show data from sent message and the data from received messages
Upvote
0
Seeing this thread @Erel is probably having a fit....
@Makumbi .. you are not reading well / understanding the replies (maybe a language thing ??)
The uploaded sample project is an exact duplicate of what you uploaded in post#1.
The only changes have been the inclusions of suggested code in post #5 to change Column Title during Runtime.
1. It does not solve other problems you are having ... (data does not show in the Table - All data! ... not just some)
(I have attempted but do not understand / follow your code)
2. try to Log / Study why it does not Display (The data seems to be arriving from http jobs OK)
Once you have decided which problem you which to solve first .. upload a small project so we might understand the issue better.
Maybe time for a fresh thread ..
Upvote
0
Thanks mangojack but the problem is when i click on the sent message i dont see the data returned that is one of my biggest concern i was trying to explain to Erel it is good that you have also seen it . but how comes that when you look at the record counter it shows you 1 out of 4 show which shows that data is already there and wen i look at my log i can see the messages and the dates properlySeeing this thread @Erel is probably having a fit....
@Makumbi .. you are not reading well / understanding the replies (maybe a language thing ??)
The uploaded sample project is an exact duplicate of what you uploaded in post#1.
The only changes have been the inclusions of suggested code in post #5 to change Column Title during Runtime.
1. It does not solve other problems you are having ... (data does not show in the Table - All data! ... not just some)
(I have attempted but do not understand / follow your code)
2. try to Log / Study why it does not Display (The data seems to be arriving from http jobs OK)
Once you have decided which problem you which to solve first .. upload a small project so we might understand the issue better.
Maybe time for a fresh thread ..
B4X:
11/04/2019 03:16 PM
good morning
java.lang.Object@5b276d5
12/04/2019 07:57 AM
good works
java.lang.Object@aefaeea
12/04/2019 03:48 PM
good boy
java.lang.Object@254f5db
12/04/2019 04:03 PM
BBC DJ's
java.lang.Object@3779878
Upvote
0
So use many logs ... at many stages ... to show where it is Breaking !
The only way I / We can help ...
1 Start a New Thread , ie: Received Data not showing in Table"
2 Upload a sample project that only contains code to ...
a. display your layout / table
a. get you data via http job ... (Only that Data / Job / Json)
b. process the Json string
c. display the processed data in b4xTable
No More ... No Less
As I stated earlier ... do that and you will probably solve the problem yourself.
Upvote
0
I had a fresh look at your sample project in an attempt to understand it more and possibly helping with your problem.
Unfortunately I am still stumped exactly what your trying to achieve (apart from getting some data and displaying in Table.)
I have made some changes to the sample to try and simplify it ... ie. the assets db file now contains all Tables and base info.
I have made comments to explain.
Also I changed some button names to make it clearer what they do in the example.
You will see comments highlighting areas not working .. (I just gave up in the end
)Probably your first stop might be ReplySMS Sub .. There is no data coming in from your http job
Possibly fix that first .
Also it might help if you added many comments explaining what you are doing / trying to do.
ie: what is the purpose of http job in Activity_Create.
It might help with future problems.
Last edited:
Upvote
0
Similar Threads
