Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Questions (Windows Mobile)
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Questions (Windows Mobile) Post any question regarding Basic4ppc.

SQl retrieve image problem

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-12-2008, 12:43 PM
Cableguy's Avatar
Basic4ppc Expert
 
Join Date: Apr 2007
Location: N 41º11'30.30" W 8º39'46.60"
Posts: 2,344
Awards Showcase
Forum Contributer 
Total Awards: 1
Default SQl retrieve image problem

HI Guys.....

Thanks to Modules Im using a specific mdule to cope with the command to and data from a database...

I Have this sub:

Code:
Public Sub Get_Assinatura(Nome,Destino)
cmd.CommandText = 
"SELECT Assinatura FROM Tecnicos Where Nome='"&Nome&"'"
Data.Value = cmd.ExecuteReader
Data.ReadNextRow
Control(Destino).Image= Data.GetImage(
0)
End Sub
This is called by the following line:
BaseDados.Get_Assinatura(Table1.Cell("Nome",Table1 .SelectedRow),AssImage)

AssImage is an image control...

But this doesn't work...
Help?!?!?
__________________
Paulo Gomes - Porto, Portugal - Living/Working in France
Mobile Device: Samsung Galaxy S, Android 2.3.4 CUstom ROM
Laptop: Toshiba NB100-130 (running on Win7Ultimate)

My Posts helped you? Consider Buying me a Porto Glass!
Reply With Quote
  #2 (permalink)  
Old 11-12-2008, 01:08 PM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

You don't say in what way it doesn't work or what error, if any, you get but here's a guess. You might need to qualify the Image control name with the module it belongs in otherwise Basic4ppc assumes it is in the module where the code is defined.

Code:
BaseDados.Get_Assinatura(Table1.Cell("Nome",Table1 .SelectedRow),<font color="Red"><b>Main.</b></font>AssImage)
EDIT :- You might need to qualify the other names as well.
Reply With Quote
  #3 (permalink)  
Old 11-12-2008, 02:30 PM
Cableguy's Avatar
Basic4ppc Expert
 
Join Date: Apr 2007
Location: N 41º11'30.30" W 8º39'46.60"
Posts: 2,344
Awards Showcase
Forum Contributer 
Total Awards: 1
Default

Quote:
Originally Posted by agraham View Post
You don't say in what way it doesn't work or what error, if any, you get but here's a guess. You might need to qualify the Image control name with the module it belongs in otherwise Basic4ppc assumes it is in the module where the code is defined.

Code:
BaseDados.Get_Assinatura(Table1.Cell("Nome",Table1 .SelectedRow),<font color="Red"><b>Main.</b></font>AssImage)
EDIT :- You might need to qualify the other names as well.
That, and a small typo, solved my issue, also added the control type.
__________________
Paulo Gomes - Porto, Portugal - Living/Working in France
Mobile Device: Samsung Galaxy S, Android 2.3.4 CUstom ROM
Laptop: Toshiba NB100-130 (running on Win7Ultimate)

My Posts helped you? Consider Buying me a Porto Glass!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
MouseMove over Image - problem DaveW Questions (Windows Mobile) 10 11-04-2008 08:27 AM
Retrieve Image from Sprite fjsantos Questions (Windows Mobile) 6 06-16-2008 04:57 PM
Problem: fetch and store image to/from database willisgt Questions (Windows Mobile) 2 05-13-2008 03:10 PM
Image problem with ImageButtons klaus Bug Reports 3 02-15-2008 08:10 AM
Image size problem agraham Bug Reports 4 10-24-2007 05:40 PM


All times are GMT. The time now is 03:15 AM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0