How I convert/import my XLS table to SQL?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to nsb-ce@googlegroups.com
To unsubscribe from
How I found the last name on the sample on TN15
I try
cmd="SELECT * FROM WHERE NameDB lastname = """ & tbLastName.Text & """"
showStatus cmd
Set r=db.Execute(cmd)
MsgBox & r &
But this not return the line.
EMERSON VIER
--~--~-
e NameDB sample
FirstName LastName
Joe Bob
Henry Bill
Tedy Herman
Thx for all
EMERSON VIER
--- In nsbasic...@yahoogroups.com, Harold Wood wrote:
>
> you need a properly formatted query.
>
>
> "select * from [table name goes here] where [column name goes
I undested your information, but I need search the data on my database by SQL
function WHERE or other.
Can you help me?
EMERSON VIER
--- In nsbasic...@yahoogroups.com, Harold Wood wrote:
>
> the query looks good now. remember that nsbasic treats a record set as a
> multidimens
Thx for all.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, Harold Wood wrote:
>
> yeah, i was thinking how to retrieve all rows in a result set.
>
> thanks
>
> woody
>
> --- On Sat, 5/23/09, Chris Kenworthy wrote:
>
>
> From: Chris Kenworthy
> Subj
How I get the status for TextBox I need Know "Show" or "Hide"
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to nsb-ce@g
7;19' ")
Work very well
But I need use the variable on place '19' because this value I need get from
TextBox
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" grou
I know abou error mensage, but I need the solution for this, my column is Age
and I need seach value for this when I make this
Set records=db.Execute("SELECT * FROM People_DB WHERE Age >= '19' ")
Work very well but I need sustitute the '19' to on variable.
Th
I try use ""Value1"", "Value1" but not work to.
Thx
EMERSON VIER
--- In nsbasic...@yahoogroups.com, brian smith wrote:
>
> Im no SQL expert.
> but I remember reading that you have to do something like this
> Set records=db.Execute( &quo
Ben,
Thx, but not work for me I test the all option.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "bwolodko" wrote:
>
> --- In nsbasic...@yahoogroups.com, "bwolodko" wrote:
> >
> > --- In nsbasic...@yahoogroups.com, "EMERSON VIER" wrote:
&
I use this
Set records=db.Execute ("SELECT * FROM People_DB WHERE Age>=
"&"'"&tbsearch.Text&"'"&" ")
Thx Woody and Ben for all help.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, Harold Wood wrote:
>
> Emereson
I read the TN30 Distributing your Application, this work very well.
But I need install my database file how do this?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To po
I need calculate the value C = A^B but the "^" not work how i do this?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to nsb
Yes I use 8.o, and try this work very well.
But now how I includ on my instalation the AXPack?
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
> I assume you are using NS Basic/CE 8.0. If not, have a look at it. This
> is something the new relea
I try ** not work, but I try ^ again and work very well.
Thx
EMERSON VIER
--- In nsbasic...@yahoogroups.com, Thomas Gruber wrote:
>
> Try C = A ** B
> Thomas
> Am 02.06.2009 um 04:49AM schrieb EMERSON VIER:
>
> >
> >
> > I need calculate the value C = A^B b
About the AXPackck it´s mok.
Now about the data base not work, my not found the database file, to work I
need past the database file under folder MYDEVICE
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
> It's the same idea.
>
>
I test too the example SQLite.nsb, the same problem the datafile "name.db"
create on the folder MYDEVICE, and I change to the folder "\Program
Files\SQLite" this not work.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "EMERSON VIER" wrote:
>
> About the
ch: 'records(...)'"
code ine is
tbI220.Text = records(1)(10)
I use the 8.0.2 version
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to th
On Desktop Menu/Help/About show the version 8.0.2, on emulator or device I use
the NSBVersion show the 8.0.0
It´s ok?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To po
I use the KeyboardStatus = -1 to show Keyboard, it´s OK show the complet
Keyboard, how I show only numeric Keyboard?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To po
then exit sub
MsgBox text & " was selected"
end sub
I download the MGCEBarsNPops.exe from this link
http://www.nsbasic.com/ce/info/BigRedToolbox/
and try instal on emulator 6.1.4 Professional 480x800 recive this message "
Control Set not support the connect device type"
EM
I use many Combox on my software, but to select option I need use the pen,
whith the finger is very hard, how I make this finger-friendly?
EMERSON VIER
HTC TOUCH HD
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
I use the "F6" to install file on emulator and device, I recive the message "Is
app open on device? Cannot copy to: ", but my program is not open...
To work I need use the "F5" to install the files.
EMERSON VIER
--~--~-~--~~~
I try test my program on SDCARD, I back to device and work.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
> We give this message when the copy to the device fails. The most likely
> reason is that the app is open on the device, but it could a
I need open .txt file and use data from this how I make this?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to nsb-ce@googlegroups.com
To u
I need send the email on HTML format I try include this text on body email
This my First Web page
Hurrah! This my First Web page.
But I recive the same format.
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are
If I undested, where I found more informantion about this.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "Chris Kenworthy" wrote:
>
> Hi. I'll just throw in that the IPworks ActiveX edition (which we get a free
> deal on last I heard!) has an HTMLMailer function b
I think need set the Content-type to text/html but how I make this?
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "EMERSON VIER" wrote:
>
> If I undested, where I found more informantion about this.
>
> EMERSON VIER
>
> --- In nsbasic...@yahoogroups.com, "Ch
I use the sample grid.nsb and includ the code
Sub grid_Click
Dim Linha
Dim Coluna
Coluna = grid.col
Linha = grid.row
MsgBox Grid.TextMatrix(Linha,Coluna)
End Sub
This work very well.
I include this code in other project, this not work, not any information;...
EMERSON
What the best way to show picture, I read the technoteS but I not undested, I
need click button and show on picture..
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To po
Thx George, Work very well.
Now I try use the event "Click" on my projetc I had four form on the Default
form this event work, but on other form not work...
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
> Use the PictureBox object.
>
&
I try again and events "click" only work on Default Form, if I try this on
other Form not work, I not get any error messages
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
> There is not enough info here to give much help.
>
> Have you
ic people!"
eAttachment="&attach=" & "benchmark.nsb"
shellExecute "open","tmail.exe", eTo & eSubject & eBody
I trys this too
shellExecute "open","tmail.exe", eTo & eSubject & eBody & eAttachment
EMERSON VIER
le "Recipe.xls" in the "My Documents" folder:
o tmail.exe -service MyMail -to nob...@nowhere.com -subject "Call Me
Tonight" -body "at 555-1212" -attach "\My Documents\Recipe.xls"
Yes I need help for this.
EMERSO
My app has many form , How I get the form is Enable or Visible?
EMERSON VIER
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to nsb-ce@googlegro
George, You have news about this?
Regards,
Emerson Vier
--- In nsbasic...@yahoogroups.com, "EMERSON VIER" wrote:
>
> I try again and events "click" only work on Default Form, if I try this on
> other Form not work, I not get any error messages
>
&g
cular form, it
might be easiest to keep a global variable for each form with its
current status.
>My app has many form , How I get the form is Enable or Visible?
>
>EMERSON VIER
>
>
>
>
>
>Yahoo! Groups Links
>
>
&g
cular form, it
might be easiest to keep a global variable for each form with its
current status.
>My app has many form , How I get the form is Enable or Visible?
>
>EMERSON VIER
>
>
>
>
>
>Yahoo! Groups Links
>
>
&g
artman"
grid1.TextMatrix(0, 2) = "1Denver"
grid1.TextMatrix(1, 2) = "1Boulder"
grid1.TextMatrix(2, 2) = "1South Park"
grid1.TextMatrix(3, 2) = "1Lakeview"
End Sub
Sub grid1_Click
MsgBox "grid1"
End Sub
Sub Comma
The problem, is grid_click only work on default form
Emerson Vier
-Original Message-
From: rmrsoft
Sent: domingo, 19 de julho de 2009 09:58
To: nsbasic...@yahoogroups.com
Subject: [nsbasic-ce] Re: Grid click
I don't have much experience of multiple forms, but if you want mul
The problem, is grid_click only work on default form
Emerson Vier
-Original Message-
From: rmrsoft
Sent: domingo, 19 de julho de 2009 09:58
To: nsbasic...@yahoogroups.com
Subject: [nsbasic-ce] Re: Grid click
I don't have much experience of multiple forms, but if you want mul
Sorry but I do not understand your reply
EMERSON VIER
--- In nsbasic...@yahoogroups.com, George Henne wrote:
>
> Have a look to how the generated code does this. Create a form with a
> grid on it, save it as txt file, then open in Notepad.
>
> Sent from my iPhone
>
>
m2_Form.Visible = False
callIfExists("Form2_Unload")
End Sub 'Form2_Hide
Sub CallIfExists(theSub)
Dim s
If ScriptEngineMajorVersion < 5 Then
Execute("On Error Resume Next:"&theSub) 'attempt to execute it
Else
On Error Resume Next
Set s
OK now the event "_Click" work on two forms, now I will make test on my project.
Why this not work when I use the AddObject??
Why I not see the properties from the this object?
Thx for you help.
EMERSON VIER
--- In nsbasic...@yahoogroups.com, "George Henne" wrote:
>
ERE CV = "& cbCV.Text &" and
Polos = "& cbPolos.Text &" ")
The recors not recive any result on next step
tbI220.Text = records(1)(10)
Show the last error.
EMERSON VIER
De: George Henne
Para: "nsbasic...@yahoogroups.
45 matches
Mail list logo