Comments by JMAM (Top 69 by date)

Hi Jaryon. It wokrs with MySQL query however it changes when i use that field in my report.

For example: SELECT date_format(`tbl_member`.`col_dateissued`,'"%D Day of %M, %Y"') AS `col_dateissued` FROM MyTABLE

The Date Will be displayed like this "1st Day of August, 2002" 8/1/2002 12:00:00 AM


I do not know why crystalreport changes it

Thanks Jayron.

Hi, thanks for the response. Can you give more details? how would i know what to insert suffix for DAY format (rd, th or nd) example if 2 its 2nd, if 23 its 23rd. if 4 its 4th.

Insert Into Statement - followed by select works only for 2 database table located in one server.

Thanks, This will be helpful. I didn't know their is a function like that But i am using MySQL would it also work?

Also Table 1 is from a MYSQL LOCALHOST while Table 2 is from a MYSQL Cloud

BTW, I would like to thank you for helping me

Hello,

Actually i just re installed my Visual Studio 2008, MySQL .Net Connector & MySQL v5.1.53
Thinking that it might be the configuration. Thus

I created a new project, With form1 i added crystal report viewer, from crystal report viewer i select create a blank report file. Thus i added a new Datasoure, select MySQL, entered necessary connection details such as server host = Localhost, User ID= root, Password = 3 then

Finally from the crystal report file Field Explorer, I click database Expert, Select ADO.NET from Project data then drag any database table then drag a few fields going to report row details. then i executed the program. Then Still no data is being showed. However when i use Microsoft report viewer, then create a report then get data from ado.net also, then i can see info when i run the application.

i am so devastated with this error now. This is my first time to encounter this. Before i can do it without any errors.


Additionally you may download my sample project, including DB, connector and other details so you may see why error actually happens and impossible for me to trace.

https://dl.dropboxusercontent.com/u/65392916/SAMPLE.rar

On Problem # 2, I didn't get DATA programatically,

NOTE: I created a DATASOURCE on design time(shft + alt + D).

Then on CRYSTAL REPORT design time, i use Database expert > Project Data> ADO.NET DataSets > v_masterfile


The problem is when i run the program report does not show any record.

Addtionally i created another dataosource using ODBC wondering if i will have different results. Then on CRYSTAL REPORT design time, i use Database expert > Project Data> ADO.NET DataSets > v_masterfile

When i run my program this time using ODBC it shows good records compared to ADO.NET on design time that shows no record at all.

Thanks for your time, Do you know the best and cheap Mysql cloud and VPS hosting companies? if yes share some of your experience with them so i have ref. :) thanks

@ Mike,

Thank you, this is a good code i just need to find someone who is able to convert this sql script to mysql.

BTW, If anyone here knows who can answer this or any experts that will charge a little for converting this, i will be glad to know.

I know that people here do not ask for any kind of payment because they help each other without a cost. But perhaps i am so desperate and would be willing to pay if that is the last option i can do.

Thank you so much sir, i am working with it now, I will update you as soon as it works with me. Now its quiet challenging at my side to solve this simple query, I have to read more and more and make a lot of experience. Honestly i am quite worried because i am running out of time and i need to finish this first edition of the software project.


I found out that TIMEFROMPARTS function doesn't work at MySQL too. Sorry for the trouble i am causing you. i know MySQL is free to download but if you need MySQL installer i can upload it my dropbox account.

I really need to translate and use this perfect code because i will use it in my app several times.

Here you will find MySQL essentials, Gui and Navicat for MySQL at: https://dl.dropboxusercontent.com/u/65392916/Database%20Tools.rar

The best thing you can do is create a new gmail account and share login information here, Just make sure the account you will share is not personal and for testing only.

In that way we can see actual errors on our own

Try to use the gmail account your are using right now. Just login on google mail then check if system ask you to enter some security codes then that is the error you are getting, probably gmail is asking for 2 steps verification.

Another advice is for you to make a new google email for testing only. Send us the exact email and password so we can test it here.

I found out at that MS SQL & MySQL has some major difference on their syntax that might be a problem for me.

DATE_ADD(date,INTERVAL expr type) - MySQL
DATEADD(datepart,number,date) - MS SQL


DATEDIFF(date1,date2) - MySQL
DATEDIFF(datepart,startdate,enddate) - MS SQL

That is why i am having those errors, your code is simple and brief that's why i like it, but i am afraid i would be needing to move to MS SQL just for this special function.

I think Port 587 is correct i have tried this before. Be sure to disable your 2 steps gmail account verification.

If it is enabled, Gmail will send you security code either to your mobile or email account then you have to enter that dynamic security code every attempts

can you check what kind of device and driver your fingerprint reader has? If its U.are.U by DigitalPersona then it would be much easier, just download SDK directly from their site then it has prototype programs and documentations

Does anyone here knows how to transfer above query from SQL to MySQL version?

i am having an error when using it to mysql it has error like below:


[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CAST(time_in as smalldatetime) As TimeIn,CAST(time_out as smalldatetime) as Time' at line 2

Can you transfer it to a MySQL version?

Thanks, I fell a sleep while coding. i am checking it now.

Thanks, Maciej Los, Actually i have tried this.

Yes this will work if, Holiday is Dec 25, 2013 and worker starts at December 24, 2013 - 10:00 PM to December 25, 2013 4:30 AM
The result below will return a value of counted minutes that is equivalent to (270) which i can devided to (60) to get the result of 4.5 working hours

Dim dt1 As DateTime = 12/25/2013 04:30:00
Dim dt2 As DateTime = 12/25/2013 00:00:00)
Dim ts As TimeSpan = dt2.Subtract(dt1)
MessageBox.Show(Convert.ToInt32(ts.TotalMinutes) & " minutes time Late")

Actual Message = "270 minutes time Late".


Possible problems on different situations:

Situation # 1

If an employee started to work December 25, 2013 3:00 AM to December 25, 2013 11:00 PM.
when "12/25/2013 00:00:00" is subtracted by "12/25/2013 23:00:00"
System will provide results of (660) minutes, when the expected answer is only (480) if i'am not mistaken, this can be handled by getting the time diiference on a time in then subtract it to the result.







Situation # 2



If an employee started to work on December 25, 2013 10PM to December 26, 2013 4:30 AM. expected answer is (120)

with the following code above, System will show answer like "-390" which is not correct



Iam still thinking about other situations that may bring discrepancies here.

Hi Mike,

Another questions relevant to my previous questions, hope you can answer.

http://www.codeproject.com/Questions/578114/DeterminplusTimeplusDifferenceplusonplusaplusholid

Great, that's all i wanted for so long can't figure to manage as short code as you have provided me.

Thank you for this answer, i will also try this one.

Thank you for this answer, i will also try this one.

Thank you So much This works great.

Thanks, Do you have an idea how to solve this?

Hi Mike,

I have a little problem with this current code, Please have a look at this for further details, Your answer are one of the closest have so far.

http://www.codeproject.com/Questions/573570/SelectplusColumnplusforpluseachplusday

Thank you mike. It works perfectly.

Because we have a biometrics device which still accepts time in even thoug employee had already done it. Likewise when you have punch it to traditional time clock using time card then once you have decided to re punch in at the same date.time clock will just over write the card.however on the device we can't modify this and what it does to simply insert new record.

Thanks for your advice btw.

Hi Mike,

Can you clarify this code assuming we have a database
table name: Raw_Record
Col1 = Emp_name
Col2 = Emp_time
Col3 = Emp_type

Ce.name = Employee Name
Eventtime = Time Record

What is ClockEvents Mince?

Thank you for quick response btw.

Done, Can you tell me where can i get good reference exploring schema.ini. my concern is what if columns change? for instance their is another model of biometrics where its first cloumn would be transaction type? how do i know if what should i put in scheme.

Got it, Thanks Marciej. :)

I tried this but when i run the app it only shows access id values in my datagrid all suceeding columns are empty

http://scn.sap.com/thread/1938836

I am getting the starting inventory based on the last transaction day ending inventory.
For instance if i made transactions from Nov 1, 2012 to Nov 30, 2012 thus i generate a report from November 15, 2012 to November 30, 2012 All products beginning inventory should come from the last ending inventory before the date range "From"

So November 15, 2012 Starting Inventory shall come from Vovember 14, 2012 ending inventory

I don't have record selection formula

Thanks for the reply unfortunately it didn't work

But the code above works perfectly when u used vb.net and mysql

Sir is there anything else what if i will be using online sms services i would prefer local services in philippines but i need to use vb.net cause i am not familiar with c#

Hello Jack,

I also need some information that i think you have the ability and the knowledge to answer me, allow me to ask you several questions.

I am developing a point of sale using vb.net and mysql however i do not know which thermal printer for POS i should use, i do not want to use dos commands cause i do not have knowledge about that.

Do you have any idea which Thermal printer will work best for me using vb.net 2008 and mysql, XP/Windows 7?

if i will use EPSON TM-U220 for my POS system what driver should i use? and do you have sample codes for me to start with?

thank you

Hi dave thanks for your reply, if i will use a printer for windows what will be the commands that i shall study?

I tried justhost.com the problem is that clients ip address should be registered to remote mysql whitelist before the app can access the db.

Can you give me an example of custom code?

Hi i have visited your site but i think they do not support visual basic .net do you have any other sites that you know

first of all i would like to thank you for spending sometime to help however i have the correct version of .net framework and visual studio but all that happens when i deploy it is like an installer. my prototype program doesn't need other dll's because it's very simple.

.Net? Did you mean .Net framework? Yes i know that i can deploy my application but when i deploy it became an installer/Setup type that you have to install it first before you can use the program i would like something like what vb6 can do make an executable software without installing it.

There is no link

Well what can i say it all works, thanks a lot :)

I think every thing that you said works perfectly and its all i need can you give me an example of minutes interval like providing me this example below.

DateDiff ("h", {Time_in}, {Time_out})

I do not know minutes interval in crystal reports thanks to your quick, bright and generous information :)

Wow thanks i didn't notice this. it works :)
One last thing sir how can i calculate exact work hours

i mean if a user time_in in at 5/17/2012 1:00 PM and Time_out 5/17/2012 3:30 PM then the result should be "2.5"

I think sir the first and second row is correct please have a look again.



5/17/2012 8:27:14AM - 5/17/2012 1:27:17PM = 5
5/17/2012 8:27:34AM - 5/17/2012 3:27:37PM = 7

Sir i you have a simple sample of this kind of prototype can you attache it also i can send you the prototype project if you want

Yes I have tried you mas see the screen shot of the report output here @ http://dl.dropbox.com/u/65392916/Public%20Photos/pic.png

What i am trying to do is create a simple time @ attendance system that will display In's and Out's of the user plus the calculated hours of work. the formula you have provided works for the two rows at the screen shots.

Also i am not that good in SQL statement using that query and to generate an output file i think crystal report would make the jobe easy am i right or i am missing the point?

thanks

Thanks once again but sir i am using MySQL and the values that i have in the database is

Time_in : 2012-05-17 20:31:08
Time_out : 2012-05-17 03:10:16
and i did exactly what you said but the result was "-17"

Thanks for sharing your knowledge and time

Hi thanks for the reply however i do know how to do this can you give me a sample code using Time_in and Time_out

Hi,

First of all i would like to thank you for taking a time answering this post.

i tried

DateDiff ("h", {Time_in}, {Time_out})

It works, but when Time_in starts at PM and Time_out is at AM
the out gives me a negative values
Example when user have a graveyard shifts

Time_in 8:00 PM
Time_out 3:00 AM

Result would be -17

Okay thanks bro, i will try this one

As i am new in Vb.net, i am sorry sir but i do understand only few.

Can you make simple program? lets say say choose Type T and a certain range and

coefficient. so i can have basis to do the program. IF anyone could help me

please do as i am new and eager to do this task and wants to help others when i can

I really need a program that will covert Microvolt output of a thermocouple to a temperature "Celcius"

Ok thank you sir i will try this one

Can you give ma simple push method made in visual basic 2008 i am in an beginners level in visual basic 2008 crystal report.thank you

Can the push method be used in visual basic 2008 as well? we are required only to use visual basic 2008.thank you

Hi Bhatt Aniruddh,

i tried to download it from the above link and change its binding source to my own database source...data greed works great showing all the contents of my database however and still, changes that was made from the datagrid during runtime doesnt affect my database...btw i am using mysql and visual basic 2008

Can you please give me a more specifc answer i'm a bit confused because i am new in vb.net