generic image
Processing...
  • Games
  • Catalog
  • Develop
  • Robux
  • Search in Players
  • Search in Games
  • Search in Catalog
  • Search in Groups
  • Search in Library
  • Log In
  • Sign Up
  • Games
  • Catalog
  • Develop
  • Robux
   
ROBLOX Forum » Game Creation and Development » Scripting Helpers
Home Search
 

Re: VB Checking if local database is empty?

Previous Thread :: Next Thread 
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 09:18 AM
How can I?
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 09:32 AM
Any visual Basic'ers out their?
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 10:09 AM
Anyone?
Report Abuse
Jellyfish403 is not online. Jellyfish403
Joined: 12 May 2010
Total Posts: 951
19 Jul 2012 10:19 AM
I believe Scripting Helpers is for help on ROBLOX Lua coding.

Jellyfish403, Administrator of Jellure Studios
Report Abuse
Vitouliss14 is not online. Vitouliss14
Joined: 18 Mar 2009
Total Posts: 7918
19 Jul 2012 10:24 AM
@Jellyfish403

No you can ask about other scripting languages as well.
Report Abuse
Jellyfish403 is not online. Jellyfish403
Joined: 12 May 2010
Total Posts: 951
19 Jul 2012 10:41 AM
Okay, well I didn't know that.
Report Abuse
triston220 is not online. triston220
Joined: 08 Mar 2010
Total Posts: 1861
19 Jul 2012 10:43 AM
You mean that there are no tables or?
Report Abuse
CeaselessSoul is not online. CeaselessSoul
Joined: 03 Jul 2012
Total Posts: 7506
19 Jul 2012 10:43 AM
Some noob: Good... Good... Vit, show him that force... Good... Good... Jelly fish USE THE FORCE...

Other guy: SHUT THE * * * * NOOB!
Report Abuse
Vitouliss14 is not online. Vitouliss14
Joined: 18 Mar 2009
Total Posts: 7918
19 Jul 2012 10:44 AM
@ceaselesssoul

Okey???????!!!
Report Abuse
CeaselessSoul is not online. CeaselessSoul
Joined: 03 Jul 2012
Total Posts: 7506
19 Jul 2012 10:45 AM
Some noob: MUAHAHAHAHA...

Other guy: Man, Imma bash your skull in, get over here!

Some noob: HOLY CRAP DA POPO AFTER MEH AGAIN! IT HAPPENIN AGAIN!
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 11:49 AM
@Triston

I mean like no entries in, well my case a users table.

So to check if my table is empty.
Report Abuse
triston220 is not online. triston220
Joined: 08 Mar 2010
Total Posts: 1861
19 Jul 2012 11:51 AM
SELECT Count(Column_Name) FROM table
Report Abuse
ghostleader is not online. ghostleader
Joined: 16 Feb 2008
Total Posts: 1131
19 Jul 2012 11:56 AM
Try this::
Dim reader as SqlCeDataReader = command.ExecuteReader()
While(reader.Read())
if reader("NameCount") = 0 then
'Redirect to Admin Form

else
'Run all your current logic here to find the user from the DB
end if
End While
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 12:17 PM
@Triston

How am I suppose to use that to tell if a table is empty?
Report Abuse
ghostleader is not online. ghostleader
Joined: 16 Feb 2008
Total Posts: 1131
19 Jul 2012 12:19 PM
@stuart6854 He's thinking of MySQL not Microsoft SQL server's.
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 12:21 PM
I'm using the Visual Basic 2010 built in local database.
Report Abuse
ghostleader is not online. ghostleader
Joined: 16 Feb 2008
Total Posts: 1131
19 Jul 2012 12:42 PM
That Databse is Microsoft SQL database, it comes with Visual Basic, i think its Microsoft SQL Server Compact 3.5ENU
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 12:43 PM
@ triston & ghostleader

In fact it does work, but how do I use the query in an If/else?
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 12:46 PM
Again doesn't matter, worked it out.

Thanks Ghost and triston!
Report Abuse
triston220 is not online. triston220
Joined: 08 Mar 2010
Total Posts: 1861
19 Jul 2012 01:02 PM
I was more than positive you could execute queries. :P

I'm glad that I could help. :)
Report Abuse
TheCapacitor is not online. TheCapacitor
Joined: 19 Jan 2011
Total Posts: 7045
19 Jul 2012 01:05 PM
Eww, VB.

lrn2goodlanguage
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 01:27 PM
I have manually add users to my table but it is giving me errors?

Error:

Now Row was updated.

The data in row 1 was not committed.
Error Source: Microsoft.VisualStudio.DataTools.
Error Message: The row value(s) updated or delted either do not make the row unique or they alter multiple rows(2 rows).

How do I fix it?
Report Abuse
stuart6854 is not online. stuart6854
Joined: 20 Oct 2008
Total Posts: 913
19 Jul 2012 01:43 PM
bump
Report Abuse
Previous Thread :: Next Thread 
Page 1 of 1
 
 
ROBLOX Forum » Game Creation and Development » Scripting Helpers
   
 
   
  • About Us
  • Jobs
  • Blog
  • Parents
  • Help
  • Terms
  • Privacy

©2017 Roblox Corporation. Roblox, the Roblox logo, Robux, Bloxy, and Powering Imagination are among our registered and unregistered trademarks in the U.S. and other countries.



Progress
Starting Roblox...
Connecting to Players...
R R

Roblox is now loading. Get ready to play!

R R

You're moments away from getting into the game!

Click here for help

Check Remember my choice and click Launch Application in the dialog box above to join games faster in the future!

Gameplay sponsored by:
Loading 0% - Starting game...
Get more with Builders Club! Join Builders Club
Choose Your Avatar
I have an account
generic image